Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |