Forum Discussion

rservice0320's avatar
rservice0320
Brass Contributor
Dec 29, 2023
Solved

sumifs with index match & > or < function

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 fil...
  • HansVogelaar's avatar
    Dec 29, 2023

    rservice0320 

    Do it this way:

     

    =SUMPRODUCT(C11:F19, (B11:B19=B7)*(C10:F10>=D6)*(C10:F10<=E6))

Resources