Dear everyone.
I have to create a new function that sum of multiplier of muti-columns like below
A B C D E F G H
Qty' Price Qty' Price Qty' Price Total
Code1: 20 5 15 6 21 5.2 =Sum(B3*C3+D3*E3+F3*G3) -> function for this fomula
Code1: 20 5 15 6 21 5.2 =Sum(B4*C4+D4*E4+F4*G4)
Code1: 20 5 15 6 21 5.2 =Sum(B5*C5+D5*E5+F5*G5)
Code1: 20 5 15 6 21 5.2 =Sum(B6*C6+D6*E6+F6*G6)
Who can help me solve it?
Many thanks to you.
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
In Excel Cell
Please Login or Register to view this content.
=GetResult(B3:G3)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
It works great.
Many thanks to you ^^
Wish you have a great day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks