Hi. This is Pritesh from Mumbai, India. I have expense codes and respective
figures in my MIS reports. If I need to sum all expenses, which contain
specfic characters or numbers in it's Exp Code, how can I do that? Maybe I
can use =Sumif or =Sum(If functions, but how? Please help.

In this example, how can I add all exps containing "East"?
Exp Codes Amt
EastZone 10
WestZone 10
NorthZone 10
SouthZone 10
EastZone 20
SouthZone 20
EastZone 30

column A B
Exp Codes Amt
=SUMPRODUCT(--(NOT(ISERROR(SEARCH("east",A2:A8)))),B2:B8)


Regards,
Stefi

€žPritesh€� ezt Ã*rta:

Hi. This is Pritesh from Mumbai, India. I have expense codes and respective
figures in my MIS reports. If I need to sum all expenses, which contain
specfic characters or numbers in it's Exp Code, how can I do that? Maybe I
can use =Sumif or =Sum(If functions, but how? Please help.

In this example, how can I add all exps containing "East"?
Exp Codes Amt
EastZone 10
WestZone 10
NorthZone 10
SouthZone 10
EastZone 20
SouthZone 20
EastZone 30

I would use a sumproduct solution

=sumproduct((a1:a10=eastx)*(b1:b10))+sumproduct((a 1:a10=easty)*(b1:b10))

you will need to expand the formula for every way you have east
followed by something else


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=567834