COUNTIF or COUNTIFS syntax issue

[K Howe]

I am trying to get a total for the number of times a specific number is entered in two separate columns.

This is the formula I used to get the total for the number of times a specific number is entered in a single column, which worked just fine:

=COUNTIFS(C5:C61,"5")


This is a sample of the formula I've been trying to use but can't seem to find just the right syntax to make it work:

=COUNTIFS(C$5:C$61,G$5:G$19,"6")

I tried using a single quote before and after the 6, that didn't work. I deleted the quotes altogether but that didn't help.
I tried =COUNTIFS(C$5:C$61,"6",G5:G19,"6").
I tried =COUNTIFS(C$5:C$61,"6",G$5:G$19,"6").

Can anyone please help?

Thank you.

[dilipandey]

Hi Howe,

Welcome to the forum.

Number should not be surrounded by quotes if that is a NUMBER not TEXT.

Try:-

=COUNTIFS(C$5:C$61,6,G$5:G$19,6).

Regards,
DILIPandey

<click on below 'star' if this helps>

[canapone]

Hi everyone,

other possibilities

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards

[K Howe]

This problem has been SOLVED. Thanks!

[dilipandey]

You are welcome k Howe

cheers

Regards,
DILIPandey

<click on below 'star' if this helps>