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

I need to count the number of rows in a spreadsheet 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

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" wrote in message
...
I need to count the number of rows in a spreadsheet 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