Forum Discussion
dportalis_123
Feb 27, 2019Copper Contributor
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...
- Feb 28, 2019
Hi dportalis_123 ,
E89 cell highlighted with green color.it's fulfill your requirement.
File is attached for your reference.
If any query remaining let me know
Best regards,
Naveen
Twifoo
Feb 28, 2019Silver Contributor
I see nothing wrong with the formula. It returns no #NAME? error as you claimed earlier.
Naveen1992
Feb 28, 2019Brass Contributor