| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF ?! .... not quite enough.... | Excel Worksheet Functions | |||
| sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
| Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Linear Mode
