Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I count the number of time 2 columns meet my criteria
0 views
Skip to first unread message
Mrswhit9
Nov 22, 2009, 5:01:01 PM11/22/09
to
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
Don Guillett
Nov 22, 2009, 5:06:12 PM11/22/09
to
try
=sumproduct((b4:b118="Consistent Support Staff")*(c4:C118="Positive"))
=sumproduct((b4:b118="Consistent Support Staff")*(c4:C118="Positive"))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguil...@austin.rr.com
"Mrswhit9" <Mrsw...@discussions.microsoft.com> wrote in message
news:B9F52CA3-53F0-493D...@microsoft.com...
Gary''s Student
Nov 22, 2009, 5:19:01 PM11/22/09
to
=SUMPRODUCT((B4:B118="Consistent Support Staff")*(C4:C118="Positive"))
--
Gary''s Student - gsnu200909
0 new messages