spittingfire
06-28-2017, 03:44 PM
Hi All,
I have what I think is an odd request.
I have the attached excel sheet and in column A (Range A1:A10) have values of either 8 or a blank. If I do a sum of A1:A10 I will get 56 however I want the sum to calculate if a cell is blank then add the value of 8. In this case the expected solution for range A1:A10 should be 80.
I'm not sure how to go about this or if it's even possible.
I'm able to do it with a helper cell but wondering if I can do it in just one formula without the use of a helper cell.
Any help will be appreciated.
Thanks
I have what I think is an odd request.
I have the attached excel sheet and in column A (Range A1:A10) have values of either 8 or a blank. If I do a sum of A1:A10 I will get 56 however I want the sum to calculate if a cell is blank then add the value of 8. In this case the expected solution for range A1:A10 should be 80.
I'm not sure how to go about this or if it's even possible.
I'm able to do it with a helper cell but wondering if I can do it in just one formula without the use of a helper cell.
Any help will be appreciated.
Thanks