**Question description:**

*This user has given permission to use the problem statement for this blog.*

Hi ,
I am trying to compare 2 if statements from 2 worksheets, if that matches then i need the count

Solved by B. Y. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
16/10/2018 - 11:19

can you help me here

Excelchat Expert
16/10/2018 - 11:19

Welcome, Thanks for choosing Got It Pro-Excel. I can help you with that problem.

User
16/10/2018 - 11:19

ok

Excelchat Expert
16/10/2018 - 11:19

Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.

Excelchat Expert
16/10/2018 - 11:19

Do you have sample data which we can use to illustrate how to solve this problem?

User
16/10/2018 - 11:19

sure

User
16/10/2018 - 11:20

[Uploaded an Excel file]

Excelchat Expert
16/10/2018 - 11:20

Just a moment as I follow closely your problem description and the data provided...please

User
16/10/2018 - 11:21

I want to comapre within worksheet 1 and 3

User
16/10/2018 - 11:22

i want to check if B1 from sheet 3 equals wth sheet 1 column C, then i need to count the no of occurences of the name from sheet 3 with respect to sheet 1 data

Excelchat Expert
16/10/2018 - 11:23

Okay. Where do you want to put the result?

User
16/10/2018 - 11:23

in sheet 3

User
16/10/2018 - 11:24

let us take an example on "Rajju"

Excelchat Expert
16/10/2018 - 11:24

The file you sent has only one sheet.

User
16/10/2018 - 11:24

it must be having 3 worksheets

Excelchat Expert
16/10/2018 - 11:25

Kindly confirm that you uploaded the correct file.

User
16/10/2018 - 11:25

I have uploaded the data in the blank file here

Excelchat Expert
16/10/2018 - 11:26

Okay. Let me have a look at it.

User
16/10/2018 - 11:27

i want a formula where B1 (sheet 2) matches with column B and if it matches, then i need the count of occurences of the name given in Column A(Sheet 2)

User
16/10/2018 - 11:27

Column B(Sheet 1)

Excelchat Expert
16/10/2018 - 11:27

Okay.

Excelchat Expert
16/10/2018 - 11:28

Based on what you’ve shared, you need a formula to count the numbers of times the name in column A appears within a particular date.

Excelchat Expert
16/10/2018 - 11:30

I am creating a formula that will solve this problem. Will get back to you shortly.

Excelchat Expert
16/10/2018 - 11:32

We are counting against the auditor column, right?

User
16/10/2018 - 11:34

yes

Excelchat Expert
16/10/2018 - 11:34

Very good.

Excelchat Expert
16/10/2018 - 11:34

Thank you for your patience.

User
16/10/2018 - 11:34

I am creating a formula that will solve this problem. Will get back to you shortly-- Thank you

Excelchat Expert
16/10/2018 - 11:34

The formula is:

Excelchat Expert
16/10/2018 - 11:34

=COUNTIFS(Sheet1!$B$2:$B$432,Sheet2!B$1,Sheet1!$D$2:$D$432,Sheet2!$A2)

Excelchat Expert
16/10/2018 - 11:35

I have put it in the online sheet.

Excelchat Expert
16/10/2018 - 11:35

Is that what you expected?

User
16/10/2018 - 11:36

Yes, perfect

User
16/10/2018 - 11:36

Thank you so so much

Excelchat Expert
16/10/2018 - 11:36

Yaaay!!!

Excelchat Expert
16/10/2018 - 11:37

I am happy for you.

User
16/10/2018 - 11:37

but if i change the date at the top

Excelchat Expert
16/10/2018 - 11:37

Do you have any other questions or clarification you may need about this problem and the solution?

User
16/10/2018 - 11:37

can we get the same data

User
16/10/2018 - 11:37

as in if i put 6-Sep-18 in place of 5-Sep-18

Excelchat Expert
16/10/2018 - 11:37

If you change the date, it will return results for that particular date.

User
16/10/2018 - 11:37

oh perfect

User
16/10/2018 - 11:37

Thank you :)

Excelchat Expert
16/10/2018 - 11:37

It was my pleasure helping you solve this problem. Any time you have a problem with Excel do not hesitate to come back for help.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*