Question description:
This user has given permission to use the problem statement for this
blog.
I have a sheet that collects data in several columns and I wish to find the number of rows that contain specific values in three columns.
so count if column N =BOB and column O =1 and column W =Jan
Cheers
Solved by G. S. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/07/2018 - 07:11
Hello
Excelchat Expert
29/07/2018 - 07:11
Welcome
User
29/07/2018 - 07:11
hi, thanks for ttrying to assist me
Excelchat Expert
29/07/2018 - 07:11
I believe I'm well equipped to solve the problem too.
Excelchat Expert
29/07/2018 - 07:12
But I need to see some more details first.
Excelchat Expert
29/07/2018 - 07:12
Can you please provide me whats in column N, O and W?
User
29/07/2018 - 07:13
N contains peoples names like "john" "bob" etc
User
29/07/2018 - 07:13
O contains a value between 1 and 4
User
29/07/2018 - 07:14
W contains a three letter value that represents a month Jan, Feb, Mar etc.
Excelchat Expert
29/07/2018 - 07:15
W contains text value Jan or the date type data?
User
29/07/2018 - 07:16
=TEXT(U25,"mmm")
User
29/07/2018 - 07:16
column U is a date
Excelchat Expert
29/07/2018 - 07:18
=COUNTIFS(N:N,"Bob",O:O,1,W:W,"Jan")
Excelchat Expert
29/07/2018 - 07:18
Please try this formula
Excelchat Expert
29/07/2018 - 07:20
Let me know if you have any question.
User
29/07/2018 - 07:21
Fantastic, works a treat. Thank you.
Excelchat Expert
29/07/2018 - 07:21
My pleasure.
User
29/07/2018 - 07:21
I was thinking too deep.
Excelchat Expert
29/07/2018 - 07:21
it happens to everyone.
User
29/07/2018 - 07:22
and trying countifs, sumifs etc. and getting no results
Excelchat Expert
29/07/2018 - 07:22
We can sometime overlook obvious things.
User
29/07/2018 - 07:22
Again thank you.
User
29/07/2018 - 07:22
Have a good day.
Excelchat Expert
29/07/2018 - 07:22
I'm glad to be help you.
Excelchat Expert
29/07/2018 - 07:22
Please click on the END button now.
Excelchat Expert
29/07/2018 - 07:22
You too have a great day!
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.
