View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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.