complex SUMIF

[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.

 

[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

 

[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

Thnx a lot, u solved my problem.

 

[Max]

welcome, glad it helped.