Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count based on criteria from two different columns
Hello,
I am sure this is a simple formula but for the life of me I can not remember. Here is my scenario: Column C (c6:c70) contains the data "won" or "lost" Column F (f6:f70) contains the data "4wd loaders" "backhoes", etc. I need to count, in another column, how many backhoes were lost and so on. Thanks, Brandy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count based on criteria from two different columns
Try this:
=SUMPRODUCT(--(C6:C70="lost"),--(F6:F70="backhoes")) Does that help? Post back if you have more questions. -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "ba374" wrote in message ... Hello, I am sure this is a simple formula but for the life of me I can not remember. Here is my scenario: Column C (c6:c70) contains the data "won" or "lost" Column F (f6:f70) contains the data "4wd loaders" "backhoes", etc. I need to count, in another column, how many backhoes were lost and so on. Thanks, Brandy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count based on criteria from two different columns
Try this array formula (ctrl-shift-enter):
=COUNT((C6:C70="lost")*(F6:F70="backhoes")) HTH, JP On Nov 13, 11:33 am, ba374 wrote: Hello, I am sure this is a simple formula but for the life of me I can not remember. Here is my scenario: Column C (c6:c70) contains the data "won" or "lost" Column F (f6:f70) contains the data "4wd loaders" "backhoes", etc. I need to count, in another column, how many backhoes were lost and so on. Thanks, Brandy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count text cells based on two criteria | Excel Worksheet Functions | |||
Count based on multiple criteria | Excel Worksheet Functions | |||
Need to count based on different criteria in two columns | Excel Worksheet Functions | |||
Count distinct based on criteria | Excel Worksheet Functions | |||
Count or Sum based on more than 1 criteria | Excel Worksheet Functions |