# Add total percent from each calculated column.

1. ## Add total percent from each calculated column.

Hi,

I would like to calculate each cell (from B to F by dividing it with 1600) and get the final average percent (below) in the Total column. Also, I don't want any calculation if a column is blank and would auto calculate once data is present. Any suggestion is greatly appreciated. Thanks! ``Please Login or Register  to view this content.``  Register To Reply

2. ## Re: Add total percent from each calculated column.

I am not 100% sure I follow your request, but I think this formula might work:

In cell G1

=AVERAGE(B1:F1)/1600

Edit: Or do you mean in 1 sheet you have the percentages and in the other you want to calculate the total number?  Register To Reply

3. ## Re: Add total percent from each calculated column.

See attached file  Register To Reply

4. ## Re: Add total percent from each calculated column.

Thanks for the prompt reply. For cells B thru F, I would like to divide each cell with 1600 and and cell G the average percentage.  Register To Reply

5. ## Re: Add total percent from each calculated column.

alansidman, THANK YOU! This is exactly what I'm looking for.  Register To Reply

6. ## Re: Add total percent from each calculated column.  Register To Reply