Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex SUMIF
I have the data in following format, and i want to sumif when the chq
no is non-blank but invoice no.s have commas in the cell. Invoice # Date Chq # Gross 0050 22-10-2007 116.00 0053 22-10-2007 58.00 0052 22-10-2007 116.00 0050,0051 abc ?? Any one can help me to sumif with comma. Thnx in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex SUMIF
Perhaps a bit more info -- Don Guillett Microsoft MVP Excel SalesAid Software "shaqil" wrote in message oups.com... I have the data in following format, and i want to sumif when the chq no is non-blank but invoice no.s have commas in the cell. Invoice # Date Chq # Gross 0050 22-10-2007 116.00 0053 22-10-2007 58.00 0052 22-10-2007 116.00 0050,0051 abc ?? Any one can help me to sumif with comma. Thnx in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex SUMIF
=SUMPRODUCT(--(ISNUMBER(FIND(",",A2:A5))),--(C2:C5<""),D2:D5)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "shaqil" wrote in message oups.com... I have the data in following format, and i want to sumif when the chq no is non-blank but invoice no.s have commas in the cell. Invoice # Date Chq # Gross 0050 22-10-2007 116.00 0053 22-10-2007 58.00 0052 22-10-2007 116.00 0050,0051 abc ?? Any one can help me to sumif with comma. Thnx in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex Sumif | Excel Discussion (Misc queries) | |||
Complex Sumif | Excel Worksheet Functions | |||
Complex VBA Sumif | Excel Discussion (Misc queries) | |||
complex SUMIF | Excel Worksheet Functions | |||
Complex SUMIF | Excel Discussion (Misc queries) |