Hi Everyone,
in my attachment, I do not get a sum total cells F18 & F19 when cells are blank and get the #value! error,
is there any make the these total cells calculate blank as 0??? the blank cells have their respected formulas which are accurate, need help to make F18 & F19 also calculate blank cells to give a total without getting an error,
please help.
Thank you in advance,
X
Replace the + with ,
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The sum function ignores text. The + operator does not ignore text. Because your formula uses the + operator, the text strings cause an error. I would recommend replacing your current sum functions with something like =SUM(E8,E10,E12...) and let the sum function ignore the text strings.
Either that, or I would drop the SUM() function and use the + operator (having them both is redundant). Then have your =IF() functions return 0 instead of "".
Originally Posted by shg
You could use one of these methods:
1.Formula:
Please Login or Register to view this content.
2.Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks everyone, all worked, i new something simple like this was right in front of me, i got using + sign too much in recent projects, i've overlooked at the formulas too hard and forgot about using " , "
much thanks too everyone.
X.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks