Hi folks.
I have the following table:
Date Type Pts Running Total # Days from "Today's Date"
3/26 Late 0.5 0.5 128
4/11 Call Sick 1 1.5 112
5/3 Call Sick 1 2.5 90
6/14 Late 0.5 3 48
6/19 Late 0.5 3.5 43
6/24 Call In 1 4.5 38
7/18 Late 0.5 5 14
7/30 Call In 1 6 2
365 day pts: (sum of pts <=365 days from today)
180 day pts: (sum of pts <=180 days from today)
90 day pts: (sum of pts <=90 days from today)
30 day pts: (sum of pts <=30 days from today)
I'm trying to enter the sum of "pts" based on the above (365, 180, 90, & 30 day). Of course, the list above is just a sample of a much larger list.
I've tried the index and match formulas, but it's just not coming up and not sure where to go with it next.
Thanks for your help,
Don
Bookmarks