Still can't get it to work. Can you give me a sample formula? I have four cells on four separate sheets which I've added. This is the formula I used:
=('Sheet1'!M9+'Sheet 2'!M9+'Sheet3'!M9+'Sheet 4'!M9)
this gives me a total of 200.
I want to get a % total and 2 of the 4 figures in the count are 0's so I don't want them to be used.