complex SUMIF
 

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.

complex SUMIF
 

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.

complex SUMIF
 

On Nov 6, 5:39 pm, "Max" wrote:
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
Singaporehttp://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.

Thnx a lot, u solved my problem.

complex SUMIF
 

welcome, glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"shaqil" wrote
Thnx a lot, u solved my problem.