The formula does not sum

[Geo Jul]

Dear All
my formula does not sum =SUM(INDEX($H$6:$S$148,MATCH(H2,$F$6:$F$148,0),MATCH(H1,H5:S5,0)))
please I need your help with this issue
your prompt action is highly appreciated

 

[6StringJazzer]

The expression inside the SUM( ) will give you a single cell. So there is no point in summing it.

Therefore I think that you have written a formula that does not do what you really want. But we don't know what you really want.

Please describe (or better yet, show) your data layout and explain what you want to do.

 

[AhoyNC]

This is a guess, but maybe:
=SUMPRODUCT(($F$6:$F$148=$H$2)*($H$5:$S$5=$H$1)*($H$6:$S$148))

 

[6StringJazzer]

If that is what you need here is an alternative. Not necessarily better.

=SUMIFS($H$6:$S$148, $F$6:$F$148, $H$2, $H$5:$S$5, $H$1)

 

[6StringJazzer]

If that is what you need here is an alternative. Not necessarily better.

=SUMIFS($H$6:$S$148, $F$6:$F$148, $H$2, $H$5:$S$5, $H$1)

Actually ignore that, it won't work. Ranges are not the same shape.

 

[Alex Blakenburg]

Actually ignore that, it won't work. Ranges are not the same shape.

Slight modification:
(Index returns a range not an array so should work on pre 365)

=SUMIFS(INDEX($H$6:$S$148,0,MATCH($H$1,$H$5:$S$5,0)), $F$6:$F$148,$H$2)

 

[Geo Jul]

Slight modification:
(Index returns a range not an array so should work on pre 365)

=SUMIFS(INDEX($H$6:$S$148,0,MATCH($H$1,$H$5:$S$5,0)), $F$6:$F$148,$H$2)

Many Thanks for your time and your help

 

[Alex Blakenburg]

Definitely a team effort, thanks for the feedback. Glad we could help,