Thread
:
Multi-Conditional Functions
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
PCLIVE
external usenet poster
Posts: 1,311
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.
Reply With Quote
PCLIVE
View Public Profile
Find all posts by PCLIVE