Quote:
Originally Posted by wickedchew
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.
|
Thanks Wicked you did it.
It seems so simple now but the "+" were messing it up. They were in the original spreadsheet, I inherited, and although they worked in the top table they returned the value error in the middle one.
Cheers
Rob