I want to sum the number of times Column B "Games" and Column E is >0.
P PCLIVE Jun 7, 2007 #2 You need to specify a range for this too work. (ex. B1:B100) =SUMPRODUCT(--(B1:B100="Games"),--(E1:E100>0)) HTH, Paul
You need to specify a range for this too work. (ex. B1:B100) =SUMPRODUCT(--(B1:B100="Games"),--(E1:E100>0)) HTH, Paul
