Or to use your named ranges use as follows:

intPeopleCount*0.01/(intTotalPeopleCount)*0.01)
--
A. Ch. Eirinberg


"Howard31" wrote:

Hi Mojo,

First use percentage format in all the cells you want to display as
percentages, including the cell that will contain the 100% result. Then in
all the peoples percentage cells use the following formula:

=C1*0.01/(SUM($C1:$H16)*0.01)

In the result cell simply use a sum formula of all the percentage people

Hope this helps.

--
A. Ch. Eirinberg


"Mojo" wrote:

Hi All

This might be an age old problem, but I just wanted to see if I wasn't
missing something obvious in my code.

Basically I have say 31 people (this figure can range from 10 to 100) who
are put into 8 categories. Once they have been categorised I simply need to
show how many are in each category as a number and as a percentage. Now the
number aspect of display is easy, but I'm coming unstuck with the percetange
aspect.

In essence as I do my % calc for each category sometimes certain values are
1% less or more than they should be and as you add up the displayed figures
the total might come out at 99% or 101%, which looks daft.

An example of a display problem is as follows

1 0 2 9 11 5 0 2 = 30 people
3% 0% 7% 30% 37% 17% 0% 7% = 101% !!!!

My code for each percentage value is simply:

Round((intPeopleCount / intTotalPeopleCount) * 100, 0) & "%"

I really want to make this work, but it seems fraught with issues!!

Any ideas?

Thanks