complex SUMIF

S

shaqil

Dear All,

I have data in following form and I want to sum of invoices which have
been written with "," (comma), e.g. 151,153 sum of Rs. 35.

Can any one help me to write this formula.


chq # Inv.# Amount
152 10
151 15
153 20
A 151,153 ?


Thnx in advance.
 
M

Max

Assuming E1 houses: 151,153

you could try in F1:
=SUMPRODUCT(--ISNUMBER(SEARCH(B2:B4,E1)),C2:C4)

where B2:B4 contains the invoice #s, C2:C4 the amounts to be summed
 
S

shaqil

Assuming E1 houses: 151,153

you could try in F1:
=SUMPRODUCT(--ISNUMBER(SEARCH(B2:B4,E1)),C2:C4)

where B2:B4 contains the invoice #s, C2:C4 the amounts to be summed
Click to expand...

Thnx a lot, u solved my problem.
 
Top