# Excel - IF Function Problem - Expert Solution

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
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
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
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.

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.