Hello !
I have a problem with the sum of a range of cells. If one of them is blank it gives me a calculation error.
I have attached an example in the post.
If there is any possibility to simplify the calculation formulas I am open to suggestions.
The sheet is for over 1000 rows.( Maybe a UDF function or VBA for speeding. I am using Excel 2010 )
Thank you in advance.
change your formula to this in E16 then double click to auto fill down... =SUM(C16:D16)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I don`t understand. Can you upload the working sheet? For me is the same error. #VALUE!
The result should be like in sheet attached!
In E16 copied down:
=IF(AND(C16="",D16=""),"",SUM(C16:D16))
Change commas to semi-colons for your locale.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks you very much! It is working!
You can close the post.
No, you have to do that.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Provide another method for reference
E16 cell formula , drag down
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks