SUMIF

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

JBoulton

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Multiple IF Statement in Word 5
SUMIF with criteria "<>" & "=" 4
Help on the Sumif Function 1
Combine Sumifs with Subtotal 0
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Multiple Columns in Sum Range using SUMIFS 1
sumif issues 1

Top