| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
