F
forevercali
It is a simple yes/no question.. Can i use the sum if function with text? Or
am i stuck with Look up?
Thanks
am i stuck with Look up?
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John C
=SUMIF(A2:A8,"yes",B2:B8)
will sum the values in B2:B8 if the text in A2:A8 is yes.
Hope this helps.
will sum the values in B2:B8 if the text in A2:A8 is yes.
Hope this helps.
F
forevercali
What if text is in B2:B8. Will it return the text or 0?
J
John C
You can't sum text, how would excel know how much "overdue"(etc.) equals out
to? Perhaps if you give a sample data set of what you have, and describe in
more detail what you are trying to calculate.
to? Perhaps if you give a sample data set of what you have, and describe in
more detail what you are trying to calculate.
R
Reitanos
As John mentioned text has no actual "value," so it can't be summed.
However, you can use the & operator to concatenate pieces of text (or
numbers).
=A1&B1&C1&D1 would get you TheQuickBrownFox if that text was in the
indicated cells
You can also add " " to get spaces: =A1&" "&B1&" "&C1&" "&D1 gets you
The Quick Brown Fox
However, you can use the & operator to concatenate pieces of text (or
numbers).
=A1&B1&C1&D1 would get you TheQuickBrownFox if that text was in the
indicated cells
You can also add " " to get spaces: =A1&" "&B1&" "&C1&" "&D1 gets you
The Quick Brown Fox
J
JBoulton
And, if your text is numeric, you can change it into a value you can then sum
using =VALUE("yourtext")
using =VALUE("yourtext")