Thread: Percentage Sum

Hi All, and thanks for any help in advance.

The sum im trying to put in a sheet is as follows
I.e.
Cell A1 minus cells A2-A6 =A7%
Cell A1 can be any number range but has to be calculated as 100% to start with

example A1 is 116 minus cell A2 is 2, A7=94%

Hope that makes sense.

Regards
Paul

THANKS SOLVED any way of hiding the #DIV/0! in the cell when no data has been input ?

=(A1-SUM(A2:A6))/A1

Format as percentage

(116-2)/116 = 98%

Regards

Please don't edit the original post after you have had a response, particularly if the original question was answered. The flow of the thread is lost and it can be difficult to follow what is going on ... at least, for the more elderly of us ;-)