Hello,
I have a sample spreadsheet attached, where under the sequence of months, I am trying to write a formula to sum all allocation % values based on the following criteria (all found in the pivot table):
1. Match the specific person named in a column (to the left of the months row).
2. Only match where the person is named AND the month column is between the Start Date field and End Date field.
I hope that was clear. Thank you for taking the time to read.
jcyr55
Bookmarks