Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.