ExcelBanter - Formula help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula help (https://www.excelbanter.com/excel-discussion-misc-queries/156343-formula-help.html)

Dale K

Formula help

Is there a formula that would help me calculate the following:
A B
1 45,000 .50
2 50,000 0
3 55,000 1
4 60,000 .25
5 65,000 0

total 92,500

Bob I

Formula help

In c1 put =A1*b1 then copy down. Sum the C column to get total

Dale K wrote:

Is there a formula that would help me calculate the following:
A B
1 45,000 .50
2 50,000 0
3 55,000 1
4 60,000 .25
5 65,000 0

total 92,500

MyVeryOwnSelf

Formula help

Is there a formula that would help me calculate the following:
A B
1 45,000 .50
2 50,000 0
3 55,000 1
4 60,000 .25
5 65,000 0

total 92,500

One way:
=SUMPRODUCT(A1:A5,B1:B5)

All times are GMT +1. The time now is 05:08 PM.