Countif

Carroll · Mar 5, 2009

Need help...

I have several columns of information. I need to: =countif(columnA,"<>X")
AND if (columnB,"=M")

What syntax do I use?

Sheeloo · Mar 5, 2009

=SUMPRODUCT(--(A1:A100<>"X"),--(B1:B100="M"))

You can add more columns ...

Change 1 and 100 to your first and last row...

Carroll · Mar 6, 2009

Thank You!! I worked perfectly.
--
Carroll

Sheeloo said:
=SUMPRODUCT(--(A1:A100<>"X"),--(B1:B100="M"))

You can add more columns ...

Change 1 and 100 to your first and last row...

Shane Devenshire · Mar 6, 2009

Hi,

If you are using 2007:

=COUNTIFS(A1:A100,"<>X",B1:B100,"M")