Countif

[Carroll]

Need help...

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

What syntax do I use?

 

[Sheeloo]

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

You can add more columns ...

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

 

[Carroll]

Thank You!! I worked perfectly.
--
Carroll

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

You can add more columns ...

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

 

[Shane Devenshire]

Hi,

If you are using 2007:

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