Countif

  • Thread starter Thread starter Carroll
  • Start date Start date
C

Carroll

Need help...

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

What syntax do I use?
 
=SUMPRODUCT(--(A1:A100<>"X"),--(B1:B100="M"))

You can add more columns ...

Change 1 and 100 to your first and last row...
 
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...
Click to expand...
 
Hi,

If you are using 2007:

=COUNTIFS(A1:A100,"<>X",B1:B100,"M")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is this an Index/Match formula? 5
Return Corresponding Value Based on Comparing Two Sheets of Data 6
CountIf or another function 4
Ranking based on two columns 2
Auditing excel sheets for everyday task 1
Return Text based upon text matching 6
Referenced Cell Values 2
How to assign unique number to column duplicates? 3

Back
Top