COUNTIF - 3 Criterian not pulling through the correct result

Hi,

I am trying to count the following:

Column Q = January
Column R = 2019
Column F = Contains ANY data

The formula I have at the minute is below.

=COUNTIFS(Data!Q2:Q1004,"January",Data!R2:R1004,"2019",Data!F2:F1004,"*")

The correct result should be 18, however the above is pulling 0 and I can't see where I've gone wrong.

Thank you!!!

Caz

Hi,
Check if January is TEXT or date formated as "mmmm"?

Try:
=COUNTIFS(Data!Q2:Q1004,"January",Data!R2:R1004,2019,Data!F2:F1004,<>"")

Hi,
I can't get this to work. The cell is formatted as Text, and when I add the <>"" and remove "" from 2019, I get the error which says there is an issue with the formula. Even if I change the cell showing January to date, "mmmm" it doesn't work.
Thanks

If it's text, it needs the quote marks round it ("2019").

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

Will you please attach a sample Excel workbook?

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

=COUNTIFS(Data!Q2:Q1004,"January",Data!R2:R1004,"2019",Data!F2:F1004,">0")

column F is formatted as numbers in each instance so >0 should work

Please note:

To mark a thread as solved, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

I've done it for you this time.