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