Forum Discussion
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...
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
Naveen, thank you, this works perfectly, solved my needs. I appreciate everyone that participated.