| 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) | |||
Linear Mode
