SUMIFS function help
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"teejay" wrote in message
...
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
|