Forum Discussion

dportalis_123's avatar
dportalis_123
Copper Contributor
Feb 27, 2019
Solved

Using IF function in a cell range

I have an IF function I am trying to use to sum a cell range but I am getting an error (#VALUE!). My formula is =SUM(E5:E32)+(IF(F5:F32="_",0,E5:E32))+(E61)+(IF(F61="_",0,E61))+(E62)+(IF(F62="_",0,E...

Resources