Forum Discussion

SigCentra's avatar
SigCentra
Copper Contributor
Nov 21, 2022
Solved

Single Cell, two dimensional array

This CSE formula is returning #VALUE!   {=SUM('3. Projects'!$H$11:$AB$154*($B6='3. Projects'!$B$11:$B$154)*($B$5='3. Projects'!$H$10:$AB$10))}   There are no errors in the underlying data and I c...
Formulas and Functions
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Nov 21, 2022

    SigCentra Tried your formula (without the sheet names) and it seem to work OK.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 21, 2022

SigCentra Tried your formula (without the sheet names) and it seem to work OK.

 

SigCentra's avatar
SigCentra
Copper Contributor
Nov 22, 2022

Thank you Riny_van_Eekelen for trying out the formula. With the formula itself passing your check, I turned my attention to the underlying data and found the culprit; an IFERROR function that returned "", rather than a value. Case closed. Thanks.