Sumif

[Pritesh]

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

 

[Stefi]

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


Regards,
Stefi

„Pritesh†ezt írta:

 

[robert111]

I would use a sumproduct solution

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

you will need to expand the formula for every way you have eas
followed by something els