Sumproduct for Dynamic ranges

[SubhasisB]

Dear All,
In the attached excel file there are two drop-down box, I want to have the sum total expenses in Q column based on the month selection by the user from drop-down box.
Please Help.

[#2]

It appears the file did not upload?

[#3 · Accepted solution]

@SubhasisB 

That could be

=SUM(XLOOKUP(O3,$C$2:$N$2,$C3:$N3):XLOOKUP(P3,$C$2:$N$2,$C3:$N3))

or

=SUM(INDEX(C4:N4,MATCH(O4,$C$2:$N$2,0)):INDEX(C4:N4,MATCH(P4,$C$2:$N$2,0)))

[#4]

@JMB17 Please find attached the file.