Hi,

For try these formulas:

for (0-5) the formua is: =SUMPRODUCT(--(A1:A1000),--(A1:A100<=5))
for (5-10) the formua is: =SUMPRODUCT(--(A1:A1005),--(A1:A100<=10))
for (over 10 the formua is: =SUMPRODUCT(--(A1:A10010))

assumed that you numbers are in the range A1:A100 and you can change it to
whatever you want.

if you change the source numbers then these numbers will change automaticaly

Thanks,
--
Farhad Hodjat


"Frikkels" wrote:

I have a spreadsheet with one column that contains random numbers - I need to
group these numbers in fields - "0-5" "6-10" & " over 10" I want to create a
Pie Chart with those three groupings, what is the best way to do this,thatt
if a number changes that it will change the quantity in one of those 3
groupings. I want it to calc automatically...any ideas, and if so please can
I have an example as well....

Many Thanks