| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Formula
Hello guys can you help
If I have rows b1 to b60 and columns a,b ,c,d .. and I want to do the following = (b3*d3) + (b4*d4) and so on and total it at the end how can I do it |
|
#2
|
|||
|
|||
|
One way:
=SUMPRODUCT(B3:B60,D3:D60) In article , SAMSON wrote: Hello guys can you help If I have rows b1 to b60 and columns a,b ,c,d .. and I want to do the following = (b3*d3) + (b4*d4) and so on and total it at the end how can I do it |
|
#3
|
|||
|
|||
Thankyou McGimpsey for your quick reply appreciated, and the frormula also works
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula in an Excel comment | Excel Discussion (Misc queries) | |||
| Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
| How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
| Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
| Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions | |||
Linear Mode
