SUMIF
 

It is a simple yes/no question.. Can i use the sum if function with text? Or
am i stuck with Look up?

Thanks

SUMIF
 

=SUMIF(A2:A8,"yes",B2:B8)
will sum the values in B2:B8 if the text in A2:A8 is yes.

Hope this helps.
--
John C


"forevercali" wrote:

It is a simple yes/no question.. Can i use the sum if function with text? Or
am i stuck with Look up?

Thanks

SUMIF
 

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

"John C" wrote:

=SUMIF(A2:A8,"yes",B2:B8)
will sum the values in B2:B8 if the text in A2:A8 is yes.

Hope this helps.
--
John C


"forevercali" wrote:

It is a simple yes/no question.. Can i use the sum if function with text? Or
am i stuck with Look up?

Thanks

SUMIF
 

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.
--
John C


"forevercali" wrote:

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

"John C" wrote:

=SUMIF(A2:A8,"yes",B2:B8)
will sum the values in B2:B8 if the text in A2:A8 is yes.

Hope this helps.
--
John C


"forevercali" wrote:

It is a simple yes/no question.. Can i use the sum if function with text? Or
am i stuck with Look up?

Thanks

SUMIF
 

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



On Oct 14, 10:44*am, John C <johnc@stateofdenial wrote:
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.
--
John C

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

"John C" wrote:

=SUMIF(A2:A8,"yes",B2:B8)
will sum the values in B2:B8 if the text in A2:A8 is yes.

Hope this helps.
--
John C

"forevercali" wrote:

It is a simple yes/no question.. Can i use the sum if function with text? *Or
am i stuck with Look up?

Thanks

SUMIF
 

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

"Reitanos" wrote:

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



On Oct 14, 10:44 am, John C <johnc@stateofdenial wrote:
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.
--
John C

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

"John C" wrote:

=SUMIF(A2:A8,"yes",B2:B8)
will sum the values in B2:B8 if the text in A2:A8 is yes.

Hope this helps.
--
John C

"forevercali" wrote:

It is a simple yes/no question.. Can i use the sum if function with text? Or
am i stuck with Look up?

Thanks