LinkBack URL
About LinkBacks
Thanks Glenn
Thanks Glenn
Last edited by sameer79; 12-27-2020 at 04:52 AM.
very confusing description. I have no idea why you highlighted F3:F6. They seem to have no role in the calculation...
=(VLOOKUP(C14,$B$3:$G$6,6,FALSE)+SUM(Addons))/$D$2
see dropdown box in C14.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Dear Glenn
Thanks for your formula.
I am looking for something like a scenario type solution.
I have copy pasted the values under column G which I am expecting for each Sub options.
I have used Columns I K and M only for explanation purpose of different scenarios.
See the new sample attached.
Thanks once again for your time
Changes in the yellow cells, formula in the orange cells. If this STILL isn't right, please post a file containing ONLY the things that are REALLY present in your sheet.
Dear Glenn
I got it worked using your technique
Thanks for your time.
Formula:
=(SUMPRODUCT(--($B$2:$B$13=H2),$C$2:$C$13,$E$2:$E$13)+SUMPRODUCT((--NOT(ISERROR(SEARCH("Add",$B$2:$B$13)))),$C$2:$C$13,$E$2:$E$13))/$C$2
Dear Shareez,
Thanks for your formula.
But it is not what I want as you are looking for the word "Add" which is a generic word.
I have posted a generic sample.
G14 then drag down:
=IF(C14="Standard",$D$3*$F$3,SUMPRODUCT(($B$3:$B$6=C14)*$D$3:$D$6*$F$3:$F$6))+SUM(Addons))/$D$2
Quang PT
Dear Bebo
When I paste your formula it gives error.
Can you paste it in my sample and post it please.
Thanks.
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks