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