Hi



I have created a sumifs formula, where on of the criteria is based on a value a user choose from a drop down menu. (User chooses week number to see numbers from a certain week.) The user should also be able to see the totals from all weeks, and choose this as the value "accumulated" in the same drop down.

What should this formula look like?

How about using a pivot table instead?

Thank you.
The layout and setup of the view would be better without a Pivot table. A formula to combine this would be better.

Example:
If user chooses A in drop down: Sumifs A.
If user chooses B in drop down: Sumifs B.

I find that hard to believe.

Perhaps post your sheet illustrating what you want.