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

  • Thread starter Thread starter Matt.Russett
  • Start date Start date
M

Matt.Russett

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
 
Excel creates names when it needs them.

If you use data|filter|advanced filter (xl2003 menus), excel can create names
without your permission or knowledge.

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
your XLStart folder) that already has these names.

If that's the case, open that template worksheet and delete the names. Then
save the template file and test it again.
 
Yeah, listen to Dave. Did you look for names, or just assume they couldn't
be there ?

Best wishes Harald
 
Back
Top