Posted to microsoft.public.excel.worksheet.functions

Foad

external usenet poster

Posts: 1

how do I use wild card in SUMPRODUCT formula?

Greetings!

I am using this formula and and it does not seem the syntax is correct:
=SUMPRODUCT(('Consolidated Report'!J5:J8941="NON ASCII; NON PRINTABLE;
NULLS; CARRIAGE CONTROL")*('Consolidated
Report'!A5:A8941<"Open")*('Consolidated Report'!LEFT(E5:E8941,6) = "R12741"))

Any help is appreciated!

Thanks

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
wild card?? formula question please	ferde	Excel Discussion (Misc queries)	6	October 11th 08 01:40 PM
Using wild card in IF formula	gcukarski	Excel Discussion (Misc queries)	3	September 19th 08 12:22 AM
wild card in sumproduct	BNT1 via OfficeKB.com	Excel Worksheet Functions	3	November 26th 07 04:10 AM
sumproduct with a search and wild card	Scorpvin	Excel Discussion (Misc queries)	1	June 14th 06 04:46 PM
wild card -- help with formula	Michael A	Excel Discussion (Misc queries)	10	January 8th 06 10:15 AM

All times are GMT +1. The time now is 08:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us