Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Counting
I have a large spreadsheet and need to know how I can count the instances of
the number "2" in one column only when the corresponding value in a different column is "medium". Can someone help with this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Counting
Try something like this example:
With A1:A100 containing sizes: large, medium, small, etc C1:C100 containing values: 1,2,5, 100, whatever Then...this formula counts the combinations of Medium/2 D1: =SUMPRODUCT(--(A1:A100="medium"),--(C1:C100=2)) Does that help? *********** Regards, Ron XL2002, WinXP "Ladyengineer" wrote: I have a large spreadsheet and need to know how I can count the instances of the number "2" in one column only when the corresponding value in a different column is "medium". Can someone help with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Conditional Filtered (By Color) Cells | Excel Worksheet Functions | |||
conditional counting with Excel | Excel Worksheet Functions | |||
conditional counting of autolist cells/rows | Excel Discussion (Misc queries) | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) |