Various scenarios based on selection criteria

Hello

I have a database of data, by year, by quarter, & by product. I am trying to create a template that allows for the user to select combinations with drop down lists. If they choose a year, they can select either the full year, or any of the individual quarters within that year, & also for ALL products or any individual products.

However, I am having trouble trying to sum the amounts (J9), based on the sections in the yellow cells of the drop down lists.

Thanks

hope this is the one you wanted result see attached

Hi accerrhod.

That works for the selections in J2 (Year) & J5(Period), but can you also include the 3rd section in J7, which wants the option off ALL prodcuts or each individual product?

I make a dummy cell to calculate all, try if you can work around, see attached file, you may hide this column if you wish.

Use this formula . No helper column and existing B column is not required.

Please Login or Register  to view this content.