How do I count the number of time 2 columns meet my criteria

's Computer Specifications

Can anyone tell me what is wrong with this formula? I am trying to say if
the text in column B = this, and the text from column C = this, and then
count the returned values:

=IF(b4:b118,"Consistent Support Staff",IF(C4:C118,"Positive"),"1","0"))

--
mrswhit

's Computer Specifications

try
=sumproduct((b4:b118="Consistent Support Staff")*(c4:C118="Positive"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Mrswhit9" <(E-Mail Removed)> wrote in message
news:B9F52CA3-53F0-493D-AD49-(E-Mail Removed)...
>
> Can anyone tell me what is wrong with this formula? I am trying to say if
> the text in column B = this, and the text from column C = this, and then
> count the returned values:
>
> =IF(b4:b118,"Consistent Support Staff",IF(C4:C118,"Positive"),"1","0"))
>
> --
> mrswhit

's Computer Specifications

=SUMPRODUCT((B4:B118="Consistent Support Staff")*(C4:C118="Positive"))

--
Gary''s Student - gsnu200909

"Mrswhit9" wrote:

>
> Can anyone tell me what is wrong with this formula? I am trying to say if
> the text in column B = this, and the text from column C = this, and then
> count the returned values:
>
> =IF(b4:b118,"Consistent Support Staff",IF(C4:C118,"Positive"),"1","0"))
>
> --
> mrswhit

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I count the number of items that meet 2 criteria?	2seas	Microsoft Excel Worksheet Functions	5	15th Mar 2009 01:47 AM
How do I count the number of cells that meet multiple criteria?	Dianna_P	Microsoft Excel Worksheet Functions	7	25th Nov 2008 05:00 PM
How do I count 2 columns of data that meet a certain criteria?	=?Utf-8?B?Um9uSm9u?=	Microsoft Excel Misc	2	15th Sep 2006 03:51 PM
How do I count the number of records that meet specific criteria?	=?Utf-8?B?SnVsaWEgU21pdGg=?=	Microsoft Access Getting Started	1	2nd Jul 2006 12:02 PM
count rows that meet two criteria in two different columns?	=?Utf-8?B?ZHNrMzgwOA==?=	Microsoft Excel Worksheet Functions	6	28th Jun 2006 09:18 PM