Countif - HELP ME!!!
 

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???
--
Marcelo Rodrigues

Countif - HELP ME!!!
 

=SUMPRODUCT(--(B1:B100="x"),--(M1:M100="y")) make the 100 whatever you want.
--
Gary''s Student - gsnu200777


"Marcelo Rodrigues" wrote:

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???
--
Marcelo Rodrigues

Countif - HELP ME!!!
 

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!!
--
Marcelo Rodrigues


"Gary''s Student" wrote:

=SUMPRODUCT(--(B1:B100="x"),--(M1:M100="y")) make the 100 whatever you want.
--
Gary''s Student - gsnu200777


"Marcelo Rodrigues" wrote:

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???
--
Marcelo Rodrigues