=SUMIF(A1:A100,"=*prj*",B1:B100)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Karel"
wrote in message
I'm trying to sum column B (minutes) that have different decriptions in
column A. I want to sum only those descriptions that have the abbreviation
of "PRJ" in them. Do I need to list out the entire descriptions somewhere
else?