Select value with with range and provide the answer based on criteria

[alekha]

As per the attachment I have selected data range

1 29
30 59
60 89
90 119
120 150

I select a value 23 which is in the range between 1 - 29 and I select the March month My result should be the sales in March for the value with range on 1-29

[Special-K]

=sumproduct((j3>=$a$3:$a$7)*(j3<=$b$3:$b$7)*(k3=$c$2:$g$2)*($c$3:$g$7))

[NickyC]

another option
=OFFSET(B2,MATCH(J3,A3:A7,1),MATCH(K3,C2:G2))