| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
I have a formula that reads =SUMIF(B11:B467,B479,D11
 467)I want B11:B467 and D11 467 to remain the same in the formula, butwant B479 to become B480, B481, B482, etc. as I move down the cells i the column. I cannot figure out how to do this. If I write th formula in one cell, then drag it down, all the numbers change... Thanks in advance for any help anyone can give me... Dre -- Message posted from http://www.ExcelForum.com |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Hi
You need to use absolute references: =SUMIF($B$11:$B$467,B479,$D$11:$D$467) -- Andy. "Drew >" <<(E-Mail Removed)> wrote in message news (E-Mail Removed)...> I have a formula that reads =SUMIF(B11:B467,B479,D11 467)> > I want B11:B467 and D11 467 to remain the same in the formula, but I> want B479 to become B480, B481, B482, etc. as I move down the cells in > the column. I cannot figure out how to do this. If I write the > formula in one cell, then drag it down, all the numbers change... > > > Thanks in advance for any help anyone can give me... > > > Drew > > > --- > Message posted from http://www.ExcelForum.com/ > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
To "freeze" references, place $'s before the column letter
and row number. The quickest way is to select the range in the formula and continue pressing F4 until you get what you want. =SUMIF($B$11:$B$467,B479,$D$11:$D$467) HTH Jason Atlanta, GA >-----Original Message----- >I have a formula that reads =SUMIF(B11:B467,B479,D11 467)> >I want B11:B467 and D11 467 to remain the same in theformula, but I >want B479 to become B480, B481, B482, etc. as I move down the cells in >the column. I cannot figure out how to do this. If I write the >formula in one cell, then drag it down, all the numbers change... > > >Thanks in advance for any help anyone can give me... > > >Drew > > >--- >Message posted from http://www.ExcelForum.com/ > >. > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
Change B11:B467 and D11
467 to $B$11:$B$467 and$D$11:$D$467. regards >-----Original Message----- >I have a formula that reads =SUMIF(B11:B467,B479,D11 467)> >I want B11:B467 and D11 467 to remain the same in theformula, but I >want B479 to become B480, B481, B482, etc. as I move down the cells in >the column. I cannot figure out how to do this. If I write the >formula in one cell, then drag it down, all the numbers change... > > >Thanks in advance for any help anyone can give me... > > >Drew > > >--- >Message posted from http://www.ExcelForum.com/ > >. > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| keeping a shape constant regardless of changes in variables | =?Utf-8?B?T3N2eQ==?= | Microsoft Excel Misc | 0 | 28th Mar 2006 04:49 AM |
| Changing a constant | =?Utf-8?B?YWNoaWRzZXk=?= | Microsoft Excel Programming | 5 | 2nd Jan 2006 11:26 PM |
| changing formula result to constant value | pemily | Microsoft Excel Discussion | 5 | 8th Dec 2005 09:44 PM |
| How do i keep the total of 3 variables constant | =?Utf-8?B?c291dGh3ZXN0cGFkZGxlcg==?= | Microsoft Excel Misc | 3 | 6th Dec 2005 11:16 PM |
| making variables constant | =?Utf-8?B?TWlsbw==?= | Microsoft Excel Worksheet Functions | 1 | 2nd Nov 2004 01:45 AM |
