Sum Base %

[r_know]

Dear All,

I am doing a Sum Up, from A1:A30, Result coming in A31.
But Cell A30 based on percentage of cell A31, say 5% of A31.
So what will be the formula in Cell A:30.

I try but coming as circular....

Reg, RL>

[Teeroy]

That will be circular. Try instead
A31 = Sum(A1:A29)/(1-5%)
and
A30 = A31 - sum(A21:A29)