Hello,

I am trying to find an array type way to write one formula, as opposed to adding 100 IF formulas together. I have a list of a few dozen projects grouped together taking up 4 rows each. I have then a calendar schedule to the right of each, where the first row in each project section is "Phase" and the 2nd row is "person days".

There are a total of 5 phases. I am trying to sum the number of person days required for each phase at the bottom, per month.

I am not sure the best way to look at the scope of the entire column, look at the value in the Phase row, then take the values in the person days row - the row below phase - and return the sum of the respective phases in a chart at the bottom of each column.

I would assume I need some combination of INDEX/MATCH/maybe SUMPRODUCT, but I cannot put it together.

Thanks!