Use Dropdown to Select Display Date Range

[OldSwimmer1650]

I'll have two columns, first column with a date (12/01/2020)
Second column with hours with a value 0-12
Every day I'll input the current date and a value for today's hours.

I would like to have a drop-down to select how to display the date list:
Daily Shows the hours in column to right
Weekly Shows the weekly total in column to right
Monthly Shows the monthly total in the column to right

[Pete_UK]

In G7 you can use this formula:

=SUMIFS(D:D,C:C,">="&F7,C:C,"<="&F7+6)

then copy down as required. You can use this formula in J7 to get the monthly totals:

=SUMIFS(D:D,C:C,">="&I7,C:C,"<="&EOMONTH(I7,0))

Again, copy down as required.

Hope this helps.

Pete

[OldSwimmer1650]

No, that wasn't quite what I was looking for. Probably my fault for not explaining it well enough.

I've attached another spreadsheet that may explain it a little better.

When I select a display option from the drop-down (Daily, Weekly, Monthly), the output will be one of the three examples I've put below
The selection from the drop-down will select the type of display output.

Daily shows the hours
Weekly shows the weekly sum of hours
Monthly shows the monthly sum of hours

Remember: Everyday I'll be adding to the list. I'm assuming this will be a table.

[Pete_UK]

Check out this file, then. I've copied your daily data to a sheet called Raw_data, and you should put any new data into this sheet as it occurs.

I've set up a data-validation drop-down in cell C2 with your three choices, but I've also given you the facility to specify a start date and an end date in cells D2 and E2 (which you could leave blank if you wish to). I figured that if you had a year's worth of data then you may not want to see all of it when selecting Daily.

The display adjusts accordingly.

Hope this helps.

Pete

P.S. I've only copied the formulae in columns C and D down to row 103 - copy them down further from that row if you need to (only really applicable if you want to see more daily data).

[OldSwimmer1650]

PERFECT! TY TY TY!

That's exactly what I was trying to do.
Now the only problem is I don't know where/how to look to see what you did.

[Pete_UK]

You're welcome, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

If you need any explanation for any of the formulae then feel free to post back, though I might not check the forum for a few days.

Merry Christmas.

Pete