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?

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?

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?

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?

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?