(Dont forget to Array-Enter it or it wont work!)

Try it. I get the same wrong answer whether it is entered normally or array
entered.

--
Regards,
Tom Ogilvy


"Duncan" wrote:

Just to be a pain in the bum.....

=SUM(A2:A11)*SUM(B2:B11) / 10

Put this formula instead, for some reason (I found out after testing)
you need to divide the initial answer by 10 to get the right answer.
dont know why, but its right and thats all that matters really.

(Dont forget to Array-Enter it or it wont work!)

Regards

Duncan






Duncan wrote:
When I say "put your two ranges in" I mean the the C column and the B
column, as you will see I only catered for the range being 250 rows
long, it might be longer I didnt know your full range.

Duncan



Duncan wrote:
=SUM(C2:C250)*SUM(B2:B250)

Put your two ranges in and Array enter this, it should be
correct........

(array enter = put formula and instead of pressing Enter, press
CTRL+SHIFT+ENTER and you will get curly brackets around it)

Let us know if this works

Duncan



ZEESHAN ANIS wrote:
I have seen in this website you people can resolve Excell issues.
I have one formula problem in EXCEL 2003
I was preparing sheet where rows are A TO AK AND Columns are 1 to 550 i am
giving the example below.


A1 PRODUCT CODE B1 Packsize in Litre C1 Quantity IN CANS
A2 42112 B2 1 C2 500
A3 42113 B3 10 C3 4000
A4 42114 B4 9 C4 2500
A5 42115 B5 11 C5 400
A550 41156 B550 C550 Total
Litre req.from C2 to C549 like C2*B2 and C3*B3 i have already applied this
formula for the sake total litre in this way.
=(C2*B$2$)+(C3*B$3$) ........(C107*B$107$)
when I was writing (C108
I have recevied message "FORMULA IS TOO LONG"

Can you please help about this error message or is there any other way to
calculate this sheet in a short way.

Thanks and Regards
ZEESHAN ANIS