Tech Support Forum banner
Status
Not open for further replies.
1 - 4 of 4 Posts

·
TSF - Enthusiast
Joined
·
4,538 Posts
Discussion Starter · #1 · (Edited)
The attached picture is my problem.

Two of the values to be added will not be figured by the "Sum" function and
I'm not sure why.
The first "30" number that won't be added is a "=IF" function
The second "30" number is a "Cell(content)" function

Does anyone know why these two dynamic values
(by dynamic I mean that every time you press enter after a change the values
of my whole chart purposely changes)
why can't they be added and if there
is a way to get the two values into my "Sum" function? :sigh:
TY
 

Attachments

·
Microsoft MVP
Joined
·
3,339 Posts
The quotes indicate they are text values, not numbers, and are ignored by the SUM function, as the Help on this function link explains:
If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored. See the third example following
If your If statement is something like this:
=IF(DAY(TODAY())=5,"30","0")
Get rid of the quotes around 30 and 0
Or you can use the Value function:
=Value(IF(DAY(TODAY())=5,"30","0"))
=Value(CELL("contents",A2))


Value will give an error if it's argument is not a numeric string, say if A2=Monday.
If you have other formulas that reference those cells and expect text, they will not work.
 

·
TSF - Enthusiast
Joined
·
4,538 Posts
Discussion Starter · #3 ·
Thank you so much.:grin:
That worked great!!
Now my sum is a sum

So I only leave quotes around stuff that is text, because all of my numeric
values also have quotes?

:wave:
 

·
Microsoft MVP
Joined
·
3,339 Posts
Yes, if it's quoted, it will be seen as text. Some functions will see that they are a number, but others won't. They ignore all text, so you don't try including labels in a total for instance.
 
1 - 4 of 4 Posts
Status
Not open for further replies.
Top