I have data on Column A and B, I would like to total up a sum by multiply A1
to B1, A2 to B2, A3 to B3 and so on. But the sum must appear on the last line
of Column B.
(in this example is B5). Thank in advance.
A B
1. 5.00 25
2. 73.40 48
3. 86.70 60
4. 14.90 237
5. ???

Enter this in B5
=SUMPRODUCT((A1:A4)*(B1*B4))

"TPG" wrote:

I have data on Column A and B, I would like to total up a sum by multiply A1
to B1, A2 to B2, A3 to B3 and so on. But the sum must appear on the last line
of Column B.
(in this example is B5). Thank in advance.
A B
1. 5.00 25
2. 73.40 48
3. 86.70 60
4. 14.90 237
5. ???

Try this:

=SUMPRODUCT(A1:A4,B1:B4)


--
Biff
Microsoft Excel MVP


"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Enter this in B5
=SUMPRODUCT((A1:A4)*(B1*B4))

"TPG" wrote:

I have data on Column A and B, I would like to total up a sum by multiply
A1
to B1, A2 to B2, A3 to B3 and so on. But the sum must appear on the last
line
of Column B.
(in this example is B5). Thank in advance.
A B
1. 5.00 25
2. 73.40 48
3. 86.70 60
4. 14.90 237
5. ???