Sum question with specific criteria

Why not upload the workbook so we have something to work with. Pictures are rarely helpful.

I was thinking this was easier... File attached

In this example I would use the cell S:4 to choose the column to search and S:6 through S:8 to specify the starting and ending row numbers to SUM

One way

=SUM(OFFSET($B$2,S6,S10-1,S8-S6+1,1))

Here are a couple more ways.

Formula:

=SUMIFS(INDEX($B$3:$P$82,,MATCH(S4,$B$2:$P$2,0)),A3:A82,">="&S6,A3:A82,"<="&S8)

or

Formula:

=SUM(INDEX($B$3:$P$83,S6,MATCH(S4,B2:P2,0)):INDEX($B$3:$P$83,S8,MATCH(S4,B2:P2,0)))

You are welcome. Thank you for the feedback. That's why we're here. Keep on learning.

Thanks for the encouragement... I plan on learning when and what I can. I do have questions about the first formula. It didn't return a value at all and I can't follow the syntax.
I plan on investigating further but I figure might as well ask if it was intended to be a fully functional formula or was that more of a helpful
nudge in the right direction?

=SUM(OFFSET($B$2,S6,S10-1,S8-S6+1,1))

Sorry,

Forgot to mention that S10 was a helper cell

=MATCH(S4,$B$2:$P$2,FALSE)

See attached