ExcelBanter - Multi-Conditional Functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multi-Conditional Functions (https://www.excelbanter.com/excel-worksheet-functions/145653-multi-conditional-functions.html)

DHaze

Multi-Conditional Functions

I want to sum the number of times Column B "Games" and Column E is 0.

PCLIVE

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.

Toppers

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.

All times are GMT +1. The time now is 09:15 AM.