Thread: complex SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shaqil shaqil is offline
external usenet poster
 
Posts: 30
Default 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.