Thank you everyone for taking time to answer my query. I tried T. Valko's
option (as it was the smallest and understandable formula to me) and it
worked.

"T. Valko" wrote:

Try this:

=SUMIF(C5:C50,"Utilities-*",E5:E50)

--
Biff
Microsoft Excel MVP