Thread: Use different sumifs based on value in drop down.
View Single Post
 
Old 12-19-2016, 09:41 AM
Prondr Prondr is offline Windows 8 Office 2013
Novice
  
Join Date: Dec 2016
Posts: 2
Prondr is on a distinguished road
Default Use different sumifs based on value in drop down.
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?
Reply With Quote