# Why do my formulas sometimes use "Extract" instead of the actual CellReference?

Matt.Russett
Guest
Posts: n/a

 4th Nov 2008
This happens to me time to time and I have no idea why. It's really
starting to tick me off!!

of example I am trying to do a SUMIF.

I Type =SUMIF(

I click Columns A and B... Formula now shows =SUMIF(A:B,

I then Click my criteria which is in C1... the formula does this
=SUMIF(A:B,Extract...

Why Extract? Why not C1? I have to type in C1 manually if I want to
fill the formula down...

I have googled it every way I can think of and found nothing.

Any help is really appreciated!

Thanks

Harald Staff
Guest
Posts: n/a

 4th Nov 2008
My guess is that the C1 cell is named Extract.

HTH. Best wishes Harald

"Matt.Russett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> This happens to me time to time and I have no idea why. It's really
> starting to tick me off!!
>
> of example I am trying to do a SUMIF.
>
> I Type =SUMIF(
>
> I click Columns A and B... Formula now shows =SUMIF(A:B,
>
> I then Click my criteria which is in C1... the formula does this
> =SUMIF(A:B,Extract...
>
> Why Extract? Why not C1? I have to type in C1 manually if I want to
> fill the formula down...
>
> I have googled it every way I can think of and found nothing.
>
> Any help is really appreciated!
>
> Thanks

Matt.Russett
Guest
Posts: n/a

 4th Nov 2008
Brand new sheet, no names

Dave Peterson
Guest
Posts: n/a

 4th Nov 2008
Excel creates names when it needs them.

If you use a criteria range, you'll have a range named Criteria.
If you use "copy to a new location", you'll have a range named Extract.

So if this is a brand new worksheet where you haven't used data|filter|advanced
filter, then maybe you're using a template worksheet (sheet.xlt*--located in

If that's the case, open that template worksheet and delete the names. Then
save the template file and test it again.

"Matt.Russett" wrote:
>
> This happens to me time to time and I have no idea why. It's really
> starting to tick me off!!
>
> of example I am trying to do a SUMIF.
>
> I Type =SUMIF(
>
> I click Columns A and B... Formula now shows =SUMIF(A:B,
>
> I then Click my criteria which is in C1... the formula does this
> =SUMIF(A:B,Extract...
>
> Why Extract? Why not C1? I have to type in C1 manually if I want to
> fill the formula down...
>
> I have googled it every way I can think of and found nothing.
>
> Any help is really appreciated!
>
> Thanks

--

Dave Peterson

Harald Staff
Guest
Posts: n/a

 4th Nov 2008
Yeah, listen to Dave. Did you look for names, or just assume they couldn't
be there ?

Best wishes Harald

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Excel creates names when it needs them.

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Joe Microsoft Excel Misc 4 1st May 2010 11:46 PM =?Utf-8?B?bGxveWRncm91cA==?= Microsoft Access 1 19th Mar 2007 06:31 PM Mr. SweatyFinger Microsoft ASP .NET 2 2nd Dec 2006 04:46 PM harry Windows XP Performance 0 15th Jan 2004 09:35 AM harry Windows XP Help 0 15th Jan 2004 09:35 AM

Features