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