Hi,
l find first variable from the table with vlookup formula and l bump with second variable. In this way, 15 lines continues one under. At the end, l take sum of the results.
The following formula can do this process, but my other tables has more than 15 lines. Can we solve this with a short formula?
The sample file is attached.
Please Login or Register to view this content.
Regards.
Sorry my language.
Thank you for your help.
This formula will do the same calculation but needs to be entererd into at least TWO cells at once. I don't know why this formula does not give the right result when put into one cell. (if someone else could elaborate on that that would be great)
Try using Control + Shift + Enter to enter this Array Formula into cells C18 and C19 at the same time
=SUM(VLOOKUP(B3:B17,E3:G23,2,0)*C3:C17)
And this formula in C20 and C21 at the same time
=SUM(VLOOKUP(B3:B17,E3:G23,3,0)*C3:C17)
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
With Vlookup and a helpcolumn.
See the attached file.
The result is in the green cells.
Please reply.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Try this formula in C19
=SUMPRODUCT(SUMIF(E3:E22,B3:B17,F3:F22),C3:C17)
change the highlighted part to G3:G22 for C20
Audere est facere
Thank you for helping. Friends,
Daddylonglegs, Formula is working perfect.
Nice Day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks