Posted to microsoft.public.excel.worksheet.functions

Pete_UK

external usenet poster

Posts: 8,856

wild card in SUMPRODUCT formula

Well, if you had checked your post on 28th August you would have had
your answer 3 days ago.

Pete

On Aug 31, 3:51*pm, Tmt wrote:
Hello,

This SUMPRODUCT won't work with the wildcard * when I tried to count all the
70222A, B, C, D and E under the "calibrated" condition. Please help.

=SUMPRODUCT(('Q3'!E12:E153="Calibrated")*('Q3'!G12 :G153="70222*"))

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
Using a wild card in SUMPRODUCT	SFC Traver	Excel Worksheet Functions	8	February 16th 09 06:11 PM
how do I use wild card in SUMPRODUCT formula?	Foad	Excel Worksheet Functions	4	October 21st 08 07:50 AM
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

All times are GMT +1. The time now is 05:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us