LinkBack URL
About LinkBacks
Hello,
I have monthly schedule with amount to be totaled by year, however some of the cells have a TBD instead of an amount. This give me an error message when trying to add all the cells.
How can I do it?
Thank you for your help!
Hello,
I have monthly schedule with amount to be totaled by year, however some of the cells have a TBD instead of an amount. This give me an error message when trying to add all the cells.
How can I do it?
Thank you for your help!
Use the SUM(...) function.
It will ignore text entries in cells.
Last edited by Tony Valko; 05-11-2016 at 12:37 PM.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
What formula are you using to SUM? SUM function ignores text.
Post a small sample file (not image): to upload, click "Go Advanced" then "Manage Attachments"
=SUM({"X",1,1})Originally Posted by JohnTopley
=SUM("X",1,1)
I'm a beginner, sorry. Only using the basic
=SUM(B49:S49)
Using that syntax, it will ignore text entries:
Data Range
This formula entered in A49:
=SUM(B49:S49)
What error are you getting? Are there any error values in the cells?
@Tony, OK .... but (I suspect) 99.9% of SUM usage is SUM(range) ......
Yeah, it's probably even higher!
To be technically correct I guess we should say the SUM function ignores text in arrays or ranges.
Last edited by Tony Valko; 05-11-2016 at 12:49 PM.
Sorry, that went to fast above. i Have attached a sample.
Thank you for your help!
Errors start in column P.
Try these...
P3: =N(P2)*-0.05
P4: =SUM(P2:P3)
Thank you! This works great adding the column!
I added the rows with =SUM(a,b,c,d) and it calculates now!
Greatly appreciate the quick responses!
Last edited by nf17; 05-11-2016 at 01:16 PM. Reason: resolved
Remove the plus signs and replace with commas:=SUM(B2+D2+F2+H2+J2+L2+N2+P2+R2+T2+V2+X2)
=SUM(B2,D2,F2,H2,J2,L2,N2,P2,R2,T2,V2,X2)
Assuming you've corrected all the formulas that were returning the errors.
Thank you Tony!!!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks