Countif - HELP ME!!!

  • Thread starter Thread starter Marcelo Rodrigues
  • Start date Start date
M

Marcelo Rodrigues

Hi everyone,

I have a sheet with several columns,,, and i need to count the number of
lines that match the condition: column B = x and column M = y.

What should i do???
 
=SUMPRODUCT(--(B1:B100="x"),--(M1:M100="y")) make the 100 whatever you want.
 
It has a error with the "," i tried ";" with no result too.

With ";" Excel does not give a error message, but does not show the correct
value.

What should i use instead of "," ???

Thanks for your help!!
 

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

Countif with two terms 3
Help with IF - THEN 5
Counting with multible conditions in a table 8
VBA Formula Help 6
countif with multiple conditions 6
COUNTIF 9
Conditional Formatting 2
value in cell B < value in cell A conditional format 3

Back
Top