| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif any text is criteria
I want to sum the numbers of one column that have text (any text) in another
column. How do I get the formula to recognize any text as the criteria rather than just a particular word? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif any text is criteria
try this after changing to suit your columns. Also checks for "the dreaded
space bar" =SUMPRODUCT((ISTEXT(H2:H22)*(LEN(TRIM(H2:H22))0)* (I2:I22))) -- Don Guillett Microsoft MVP Excel SalesAid Software "Question, Mark" wrote in message ... I want to sum the numbers of one column that have text (any text) in another column. How do I get the formula to recognize any text as the criteria rather than just a particular word? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif any text is criteria
Hi,
Try this =SUMIF(D6:D12,"*",E6:E12) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Question, Mark" wrote in message ... I want to sum the numbers of one column that have text (any text) in another column. How do I get the formula to recognize any text as the criteria rather than just a particular word? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif any text is criteria
Thanks. That's exactly what I needed.
"Ashish Mathur" wrote: Hi, Try this =SUMIF(D6:D12,"*",E6:E12) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Question, Mark" wrote in message ... I want to sum the numbers of one column that have text (any text) in another column. How do I get the formula to recognize any text as the criteria rather than just a particular word? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif any text is criteria
You are welcome
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Question, Mark" wrote in message ... Thanks. That's exactly what I needed. "Ashish Mathur" wrote: Hi, Try this =SUMIF(D6:D12,"*",E6:E12) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Question, Mark" wrote in message ... I want to sum the numbers of one column that have text (any text) in another column. How do I get the formula to recognize any text as the criteria rather than just a particular word? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif , 2 criteria, text must equal | Excel Discussion (Misc queries) | |||
| SUMIF need to add another criteria | Excel Discussion (Misc queries) | |||
| is there any way to have multiple TEXT criteria in a 'sumif' funct | Excel Worksheet Functions | |||
| SUMIF/SUMPRODUCT/IF - 2 criteria - Date and Text | Excel Discussion (Misc queries) | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
Linear Mode
