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
Naveen1992
Feb 28, 2019Brass Contributor
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
- dportalis_123Feb 28, 2019Copper ContributorNaveen, thank you, this works perfectly, solved my needs. I appreciate everyone that participated.
- Naveen1992Mar 01, 2019Brass Contributor
- TwifooFeb 28, 2019Silver ContributorI see nothing wrong with the formula. It returns no #NAME? error as you claimed earlier.
- Naveen1992Feb 28, 2019Brass Contributor