How can I write this sumproduct formula using the countifs function?

Hello to everyone,

I am currently using the following formula:

=IF(SUMPRODUCT(--(BIF3:BIT3=CHAR(252))),CHAR(251),CHAR(252))

which works fine, however, I've been trying to get the same results using the countifs function but I can't seem to be getting it right.

I've tried this formula

=IF(COUNTIFS(BIF3:BIT3,"=CHAR(252)"),CHAR(251),CHAR(252))

this one

=IF(COUNTIFS(BIF3:BIT3,"CHAR(252)"),CHAR(251),CHAR(252))

and this one

=IF(COUNTIFS(BIF3:BIT3,"CHAR(252)")>=1,CHAR(251),CHAR(252))

but I keep getting wrong results.


What's the mistake in the above countifs formulas?


Thank you
Sans

How about?

=IF(COUNTIFS(BIF3:BIT3,CHAR(252)),CHAR(251),CHAR(252))