you are correct. that's what I was getting at.

The sumif should take care of what is being asked.

"SteveG" wrote:


I think what Jonathan is getting at is that does the text in A1:A4
contain additional text like,

The spring...

spring up...

or something like that. If so use wildcard characters before and after
the work spring in the SUMIF formula.

=SUMIF(A1:A14,"=*spring*",B1:B14)

This will also take into account any preceeding or trailing spaces.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=508160