SUMIF

[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

 

[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.

 

[forevercali]

What if text is in B2:B8. Will it return the text or 0?

 

[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.

 

[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

 

[JBoulton]

And, if your text is numeric, you can change it into a value you can then sum
using =VALUE("yourtext")