MTD and YTD in a running total

[MKaye02]

As stated in a previous thread I am creating a KPI dashboard for my company. In this dashboard there are 24 data sheets that connect to the dashboard that can be viewed by the week of MTD or YTD. One of the data sheets is for a client count which is a running total. Which obviously doesn't work like a normal MTD or YTD function. I have "today's date" in the sheet and need the MTD and YTD to reflect the newest number as it relates to "today's date" so that it will still show data when MTD or YTD is chosen in the dashboard. Can someone please help me with hoe to do this??

I really hope this makes sense.

 

[01-7700]

=COUNTIFS(Sheet1!B$1:B$9999,Sheet1!$A$1:$A$9999,">="&date(year(today()), month(today()),1)

So in Sheet1 I have 2 columns, date and the counted variable. This one will count MTD, modify as needed for YTD.