Rayne
asked on
excel formula Help please
Hello All,
There are two named ranges or cells that store the mode values and product list at any point in the worksheet
So that sum would be the sumproduct or sumif of the types selected. If no types selected, it will simply add up all the types.
Fro example if range [mode] has m1 and range [types] has type1, type2,type3 then cell C24 should display 1357. If range [types] is empty, then the sum will return the total for m1 mode = 2244
How do I set up the formula to do this?
sampleExample101.xlsx
There are two named ranges or cells that store the mode values and product list at any point in the worksheet
So that sum would be the sumproduct or sumif of the types selected. If no types selected, it will simply add up all the types.
Fro example if range [mode] has m1 and range [types] has type1, type2,type3 then cell C24 should display 1357. If range [types] is empty, then the sum will return the total for m1 mode = 2244
How do I set up the formula to do this?
sampleExample101.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Here is another one if you are interested
https://www.experts-exchange.com/questions/28084271/Excel-Formula-Help-Part-2.html
https://www.experts-exchange.com/questions/28084271/Excel-Formula-Help-Part-2.html
ASKER
Hello NB_VC,
I am trying to understand your formula but having hard time understanding. Can you exaplin how to got to that formula - "--" before sumproduct as well - not sure what that means too?
Thank you
I am trying to understand your formula but having hard time understanding. Can you exaplin how to got to that formula - "--" before sumproduct as well - not sure what that means too?
Thank you
ASKER
Hello How are you
ASKER
Thank you NB_VC :)
Can you break it apart and explain how that’s working – it’s a long formula but does it perfectly as I needed
Thank you