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

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

Hi Farhad,
Thanks for this, I tried the formula, with my column that has the values (
in different sheet )....
=SUMPRODUCT(--([Table1.xls]Table1!$J:$J0),--([Table1.xls]Table1!$J:$J<=5))
.....but it does not return the value - it shows " #Num "
did i do something wrong??
"Farhad" wrote:

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