sumif any text is criteria

Q

Question, Mark

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?
 
D

Don Guillett

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)))
 

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

SUMIF with criteria "<>" & "=" 4
Use TODAY() function as the criteria in a SUMIF formula 1
Excel does not accept text format! 0
SUMIFS, one criteria range, multiple criteria 2
Multiple Columns in Sum Range using SUMIFS 1
Autonumber field in Excel that behaves the same as Access 0
Adding Heading to Table of Contents after a column break 1
How to center adjust text above and image in a two column document. 1

Top