kramtronix
New Member
- Joined
- Mar 28, 2006
- Messages
- 47
OK, I trolled da innerwebz for about 30 minutes looking for a solution to my problem, but came up empty. Plenty of answers out there, but none were applicable this formula.
=SUMPRODUCT(E99:E105,F99:F105)/SUM(E99:E105)
How do I get this to ignore zeroes?
=SUMPRODUCT(E99:E105,F99:F105)/SUM(E99:E105)
How do I get this to ignore zeroes?