Hello ALL,

I am new to excel and I would like some help please.

Basically I have a table where in column A2 I have sales people and starting from B2 to B28 I have Months in date format. Just above each month cells, I keyed in the respective financial fear so from Cells A2 to A14 I have the value of 21 and from A15 to A28 I have the value of 22. In the table below there all sort values in each month and by sales people.

What I would like to do is sum up the total values falling in each FY by sales person. So I wold total FY 21 and 22 By sales person.

I have tried sumif with index and match but it only picks up the 21 values of the first months (i.e March 21 in cell B2 has 21 in A2 but the formula does not sum April 21 in C2)

I hope it all makes sense.

Thank you so much for the help.

Bruno