Thread
:
Complex SUMIF
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett