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 |
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 |
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 |
All times are GMT +1. The time now is 01:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com