Duncan had the right idea, but the implementation is incorrect. Also, the
formula he suggest doesn't need to be array entered (but in either case,
returns the wrong answer because it adds up each column first, then does the
multiplication).

i.e. It multiplies the sum of column b by the sum of column c (rows 2 to
250).

this is how it should be correctly implemented:
=Sumproduct($C$2:$C$549,$B$2:$B$549)

this doesn't need to be array entered either.




--
Regards,
Tom Ogilvy


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