Query
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
|