Hi,
Suppose I have a range from A1 to C6
I need to calculate a % out of these 18 cells
I currently use the formula: (sum(A1:C6)*18)/100
This is correct if all cells contain a value, but whet if 3 cells are left
empty???
What should the formula be in that case?
Thanks
JP