Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

SUMPRODUCT formula I think w/ wild card & number vs number as text

Hi Howard,

Am Tue, 18 Feb 2014 07:49:37 -0800 (PST) schrieb L. Howard:

https://skydrive.live.com/#cid=9378A...121822A3%21326

for workbook "CountIf"
The usual suspect to cause the error in this case was ME. Misspelled sheet name.

no matter, such things can happen.

In SkyDrive now are 4 formulas to count substrings

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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 in SUMPRODUCT formula	Tmt	Excel Worksheet Functions	8	August 31st 09 06:58 PM
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
wild card in sumproduct	BNT1 via OfficeKB.com	Excel Worksheet Functions	3	November 26th 07 04:10 AM
Wild card in two condition text formula	Dave Peterson	Excel Discussion (Misc queries)	0	March 3rd 06 06:33 PM

All times are GMT +1. The time now is 06:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us