Feb 27 2019 06:39 AM
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,E62))+(E64)+(IF(F64="_",0,E64))
This is what I am trying to accomplish, I am summing cells E5:E32,E61,E62,E64 in cell E88, the if function needs to return 0, if the adjacent cells F has a value of "_" . Any suggestions would be greatly appreciated.
Feb 27 2019 08:27 AM
Feb 27 2019 08:52 AM
Feb 27 2019 09:19 AM
Feb 27 2019 09:27 AM
Feb 27 2019 09:56 AM
sum total is cell E88, sample attach
Feb 27 2019 10:53 PM
Feb 28 2019 12:57 AM
SolutionHi @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
Feb 28 2019 01:24 AM
Feb 28 2019 01:50 AM
Feb 28 2019 06:40 AM
Feb 28 2019 09:08 PM
Feb 28 2019 12:57 AM
SolutionHi @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