Quote:
Originally Posted by eBoof
Thanks Wicked. That works great for the top and bottom table but returns "" in all rows of the middle table. I'm sure there's probably a simple solution. I'll check it out further when I get home. In the meantime do you have any ideas?
Cheers
Rob
|
Cell V20 should have:
=IF(SUM(B20,D20,F20,H20,J20,L20,P20,R20,T20)0,SUM (B20,D20,F20,H20,J20,L20,P20,R20,T20),"")
Use comma instead of a + operand.