Summing the results of multiple cells based on other data

[DavidWT87]

Hello

Just from a bit of curiosity, I want to look into F1 points history using the current format, and would like an efficient way to speed up the process.

As an example, from this data here, I would like a formula to return the total number of points in L4 based on the finishing positions from E4 to K4

Columns A and B show the points awarded for each type of finishing position. I need L4 to match each cell from E4 to K4 in turn with the position in column A, and sum the corresponding points that are associated with each result.

I.e from E4 to K4 - it'll see 1F, blank, blank, 1F, 4F, 7, 1 and sum the corresponding points for those positions - 26,0,0,26,13,6,25 for a total of 96

I could put something pretty convoluted together myself, but would ideally like something a bit more elegant than I'm capable of doing!

 

[Fluff]

How about

=SUM(SUMIFS(B:B,A:A,E4:K4))

 

[DavidWT87]

Ah, yes that does the job, and far more simple than I was expecting. Thank you!

How about

=SUM(SUMIFS(B:B,A:A,E4:K4))

 

[Fluff]

You're welcome & thanks for the feedback.