Countif - HELP ME!!!

's Computer Specifications

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

's Computer Specifications

=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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF is Off by 1	GooseMA	Microsoft Excel Misc	4	8th Dec 2009 05:04 PM
Can I use COUNTIF with OR?	AA Arens	Microsoft Excel Discussion	3	20th Nov 2006 04:11 PM
How do I use a countif function according to two other countif fu.	=?Utf-8?B?S2lyc3R5?=	Microsoft Excel Worksheet Functions	2	20th Feb 2006 11:44 AM
COUNTIF or not to COUNTIF on a range in another sheet	=?Utf-8?B?RWxsaWU=?=	Microsoft Excel Worksheet Functions	4	15th Sep 2005 10:06 PM
COUNTIF in one colum then COUNTIF in another...???	=?Utf-8?B?Sm9ubmllUA==?=	Microsoft Excel Worksheet Functions	3	22nd Feb 2005 02:55 PM