Posted to microsoft.public.excel.programming

shaqil

external usenet poster

Posts: 30

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Complex Sumif	El Bee	Excel Discussion (Misc queries)	6	March 13th 09 09:00 PM
Complex Sumif	JPS	Excel Worksheet Functions	3	September 10th 08 10:24 AM
Complex VBA Sumif	Jeff	Excel Discussion (Misc queries)	4	May 17th 08 05:36 PM
complex SUMIF	shaqil	Excel Worksheet Functions	3	November 12th 07 02:14 PM
Complex SUMIF	Evan	Excel Discussion (Misc queries)	4	October 18th 07 11:20 PM

All times are GMT +1. The time now is 12:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us