Sum the Last 3 matches

[seal206]

I am doing and excel table for the team match record but I have no idea how to calulate the “Last 3 Home Score Sum” automatically.

F6 = last three of B6 score total = D2 + E3 + E5
F7 = last three of B7 score total = E3 + E5 + D6
F8 = last three of B8 score total = E5 + D6 + D7

Bros ! is it possible to do it in excel, any suggestion and idea can help me ?

test.xlsx

[FDibbins]

Hi, welcome to the forum

You could probably do this with SUMIFS and use LARGE as 1 if teh criteria. However, Im not going to re-type your data from a pic, can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[seal206]

thanks your reply, i uploaded the attachment in the thread, this is the sample for my workbook.

[kvsrinivasamurthy]

ARRAY formula in F2 then drag down

Please Login or Register  to view this content.