Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multi-Conditional Functions
I want to sum the number of times Column B "Games" and Column E is 0.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multi-Conditional Functions
You need to specify a range for this too work. (ex. B1:B100)
=SUMPRODUCT(--(B1:B100="Games"),--(E1:E1000)) HTH, Paul "DHaze" wrote in message ... I want to sum the number of times Column B "Games" and Column E is 0. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multi-Conditional Functions
=SUMPRODUCT(--(B2:B100)="Games"),--(E2:E100)0))
"DHaze" wrote: I want to sum the number of times Column B "Games" and Column E is 0. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting - multi-item text list | Excel Worksheet Functions | |||
multi conditional searching | Excel Worksheet Functions | |||
multi-conditional expense tracking problem | Excel Worksheet Functions | |||
Multi functions | Excel Worksheet Functions | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) |