• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

help with formulas

Status
Not open for further replies.

keasha

Member
hi apolgies i posted yesterday

i have data by date , by category and by location.

i am hoping for help with being able to just return the daily data in the front tab based on a date drop down (see data tab), by category type and location and also at a total level.

and then to sum up to a YTD position ( see data is split into M T W T F based on the date) but if i wanted the daily data as at 26/3/20 and also the YTD data (23/3/20 to 26/3/20)

hoping someone may be able to please assist with this!
 

Attachments

  • Book1.xlsx
    26.2 KB · Views: 1
Status
Not open for further replies.
Back
Top