Posted to microsoft.public.excel.misc

fractallinda

Posts: n/a

Wildcard with sumif

I'm trying to get the sum of a list of numbers that start with a certain
number (in this example 1). I can't seem to make any wildcard work. My
numbers all have 5 digits so I've tried 1* and 1????.
=SUMIF(A1:A307,"1*",F1:F307)
=SUMIF(A1:A307,"1????",F1:F307)
don't work. Will someone please tell me what I'm doing incorrectly? Thanks
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
How to use SUMIF to return sums between two values located in cells	ScottBerger	Excel Worksheet Functions	2	April 23rd 23 09:05 PM
SUMIF	Ferg	Excel Worksheet Functions	3	February 28th 06 03:37 AM
How do I use wildcard characters in Excel 2003 sumif formula?	Erik T	Excel Worksheet Functions	1	February 13th 06 08:41 PM
Sumif using wildcard	claireanddoug	Excel Worksheet Functions	1	September 22nd 05 10:17 PM
SUMIF, wildcard and cell ref	Dave	Excel Worksheet Functions	2	January 31st 05 08:13 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us