CountIf Multiple Criteria with #N/A

[DDH]

CountIf Multiple Criteria with #N/A
I have tried
COUNTIF(COUNTIFS($B$1:$B$5,$B$1:$B$5,{"-#N/A"},$A$1:$A$5,D1))
I thought this would work but something is wrong.

***A*****B*****C****D****E
1*Mon****2**********Mon**2 (Formula Here - E1)
2*Tue****3****************
3*Mon****4****************
4*Thr***#N/A**************
5*Fri****#N/A**************

Thank you for your help

 

[DDH]

I did not have this set correctly.
This should make more sense.
To count the "Mon" with numbers only.


COUNTIF(COUNTIFS($B$1:$B$5,$B$1:$B$5,{"-#N/A"},$A$1:$A$5,D1))



***A*****B*****C****D****E
1*Mon****2**********Mon**2 (Formula Here - E1)
2*Tue****3****************
3*Mon****2****************
4*Thr***#N/A**************
5*Mon**#N/A**************

 

[T. Valko]

I did not have this set correctly.
This should make more sense.
To count the "Mon" with numbers only.


COUNTIF(COUNTIFS($B$1:$B$5,$B$1:$B$5,{"-#N/A"},$A$1:$A$5,D1))



***A*****B*****C****D****E
1*Mon****2**********Mon**2 (Formula Here - E1)
2*Tue****3****************
3*Mon****2****************
4*Thr***#N/A**************
5*Mon**#N/A**************

Try this...

=COUNTIFS(A1:A10,D1,B1:B10,"<1E100")

 

[DDH]

T. Valko - Thank you for your help.

What if you had text instead of numbers.

***A*****B*****C****D****E
1*Mon****Dog**********Mon**2 (Formula Here - E1)
2*Tue****Cat****************
3*Mon****Dog****************
4*Thr***#N/A**************
5*Mon**#N/A**************

 

[T. Valko]

T. Valko - Thank you for your help.

What if you had text instead of numbers.

***A*****B*****C****D****E
1*Mon****Dog**********Mon**2 (Formula Here - E1)
2*Tue****Cat****************
3*Mon****Dog****************
4*Thr***#N/A**************
5*Mon**#N/A**************

Like this...

=COUNTIFS(A1:A10,D1,B1:B10,"*")

 

[DDH]

T. Valko - Thank you for your help.

I understood the numbers formula, my approach was way off.
I do not understand the text formula.
COUNTIFS(A1:A10,D1,B1:B10,"*")

What does the "*" do.

Both formulas work perfect, thank you.

 

[T. Valko]

T. Valko - Thank you for your help.

I understood the numbers formula, my approach was way off.
I do not understand the text formula.
COUNTIFS(A1:A10,D1,B1:B10,"*")

What does the "*" do.

Both formulas work perfect, thank you.

The asterisk is a wildcard that stands for "any text".