For the percentages to appear below your raw data (A2:F2), the formul
should be entered in (A3:F3).
In summary, the formula
=if(A2="","",A2/(sum($A$2:$F$2))
or
=if(A2="",0,A2/(sum($A$2:$F$2))
should be entered in Cell A3 and copied up to cell F3.
Again, sorry for the erroneous previous posts ... it's been a long da
and I will now quit posting until tomorrow.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.