Multi-Conditional Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to sum the number of times Column B "Games" and Column E is >0.
 
You need to specify a range for this too work. (ex. B1:B100)

=SUMPRODUCT(--(B1:B100="Games"),--(E1:E100>0))

HTH,
Paul
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excell - two conditions count if factors are true when negative nu 2
Conditional Sum function does recognise % 2
Formula appears, but its function is not performed????? 1
How to count the maximum number flanked by zeros 9
Can I have two conditions in a SUMIF? 5
SUM - IF - AND 7
Multi-condition SUMIF 4
Two Condition - search 2

Back
Top