sumif any text is criteria

  • Thread starter Thread starter Question, Mark
  • Start date Start date
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?
 
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)))
 
Back
Top