I am getting a #value! error with the following formula: =SUMIFS(INDEX($C$11:$F$19,,MATCH($B$7,$B$11:$B$19,0)),$C$10:$F$10,">="&D6,$C$10:$F$10,"<="&E6) I have also attached my file. Any help would be greatly appreciated.

rservice0320 Do it this way: =SUMPRODUCT(C11:F19, (B11:B19=B7)*(C10:F10>=D6)*(C10:F10<=E6))

Forum Discussion

Brass Contributor

Dec 29, 2023

Solved

I am getting a #value! error with the following formula:

=SUMIFS(INDEX($C$11:$F$19,,MATCH($B$7,$B$11:$B$19,0)),$C$10:$F$10,">="&D6,$C$10:$F$10,"<="&E6)

I have also attached my file. Any help would be greatly appreciated.