Re: in excel how do i - countif(A:A like "1234" AND C:C=4)

Hi

Try
=SUMPRODUCT((ISNUMBER(FIND("BET",$A$1:$A$1000)))*($C$1:$C$1000=4))

--
Regards

Roger Govier


"TPS" <TPS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5797075D-3C2A-412E-988F-974D98B361C0@xxxxxxxxxxxxxxxx
I need to count the number of rows in a spread*** where a specific
value is
contained within one column and a specific value is contained in a
second
column
for example
count the number of rows where column A contains BET and column C
contains 4
this would match for row 3 if A3 is "A BET MADE" and C3 = 4
it was also match for row 5 if A3 is "BET Voic" and C3 = 4

since there are thosands of rows i do not want to loop through all


.