Quote:
Originally Posted by wickedchew
You should introduce the ISERROR function for your formulas in column V so that your Max, Mean and Median won't return an error.
Like, V3 should have:
=IF(ISERROR(IF(SUM(B3+D3+F3+H3+J3+P3+R3+T3)0,SUM( B3+D3+F3+H3+J3+P3+R3+T3),"")),"",IF(SUM(B3+D3+F3+H 3+J3+P3+R3+T3)0,SUM(B3+D3+F3+H3+J3+P3+R3+T3),""))
|
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