I have a column that has various repeated dates. I am trying to base calculations off of groupings from the dates.

IRN Name Start Status 3 Week / Orientation / Attendance Wk1 Wk2 Wk3 Pass 1 01/00/00 0 2 0 01/00/00 0 3 0 01/00/00 0 4 0 01/00/00 0 5 01/00/00 0
So I need a way to group the start dates and associated data from columns wk1, wk2, wk3 so I can preform calculations on this data.

e.g. I have three student who started 2 weeks ago and 3 students that started a week ago. I need to calculate percentages who posted on wk1, wk2 and so on without affecting the calculations of students who started earlier or later.

The only thing I can think of is nested if statements.

Attached Files

Help.xlsx (15.5 KB, 10 views)

I am not 100% certain that I have correctly understood what you are trying to achieve, but it sounds like the COUNTIFS and/or SUMIFS functions might be of assistance.