Avatar of Rayne
Rayne
Flag for United States of America 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
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rayne

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
NBVC

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Rayne

ASKER
This is PERFECTION to the Ultimate.
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
Rayne

ASKER
Rayne

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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Rayne

ASKER
Hello How are you