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
|