Hi Guys! I'm new to ExcelGuru and I have a question that has been keeping me up at night..

I am working on an attendance tracker and each month of the year has its own sheet in the same workbook. Then I have an overall sheet.


On the overall sheet I would like a column for to find out how many points they have for 4 months running total. (Example: if today is August 11th, I would like to know their total points from sheets May (11th to 31st), June, July, and up to August 11th) and it to update based on today's date.


I have tried different formulas and and all I want to do is kick and scream when I end up with different problems.