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

[Guest]

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

 

[Roger Govier]

Hi

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