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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"shaqil" wrote in message
ups.com...
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.