| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
complex SUMIF
welcome, glad it helped.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "shaqil" wrote Thnx a lot, u solved my problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex SUMIF/COUNT IF | Excel Discussion (Misc queries) | |||
| Complex SUMIF | Excel Discussion (Misc queries) | |||
| Complex SUMIF question | Excel Worksheet Functions | |||
| How to use complex criteria in SUMIF() | Excel Worksheet Functions | |||
| SumIf formula with complex criteria | New Users to Excel | |||
Hybrid Mode
