Hi guys,
I have a question that has been on brain for the last couple of hours....
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.
I have a question that has been on brain for the last couple of hours....
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.