Functions for getting a sum for a time period

[Ryprice]

I am currently making a spreadsheet where the user can pick a time frame and depending on that selection, a function will sum up the time frame that the individual has selected. Currently, I have two data validation boxes that allow the user to pick the time frame but I cannot think of how to get a function to be flexible enough to change with the time frame. Does anyone have any ideas of what function I could use? There are also stores numbers that are involved to pull the correct information.

TYIA!

 

[dreid1011]

I can think of what to use, but I would need to see a sample of how your data is setup and how those store numbers are involved.