SUMIF the criterion contains a specified substring

Topic

New Reply

Using SUMIF, I want to sum all items where the criterion cell contains a specified substring (say, “Feb”). I tried specifying “*Feb*”, but that seems to work only if the “Feb” is at the start of the criterion string. Does this make sense? Any ideas?

Thanks

Reply | Quote

Replies

Wild card works. Perhaps your dates are being interpreted as 2/1/2013. Use an underscore instead of a hyphen if applicable.
=SUMIF(A2:A6,”*Feb*”,B2:B6)

33018-sumif

HTH,
Maud

Reply | Quote

Works ,this time, thanks. Don’t know what I was doing wrong last time, but I’m now full steam ahead. Thanks.

Reply | Quote