 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Stable formula
Let say I have this formula, =SUMIF('TSJ Student List'!C3:C118,"=4",'TSJ Student List'!A3:A118) My question is how can I use only rows C3:C118 and A3:A118 and the only changes is "=4" to 5,6 ....because when I copy or drag it will change to C4:C119, A4:A119 ..... I try to use $C3:C118$ or $c3$:$c118$ but it does not work. Please guide me. Thanks. > Let say I have this formula, > =SUMIF('TSJ Student List'!C3:C118,"=4",'TSJ Student List'!A3:A118) > My question is how can I use only rows C3:C118 and A3:A118 and the only > changes is "=4" to 5,6 ....because when I copy or drag it will change to > C4:C119, A4:A119 ..... I try to use $C3:C118$ or $c3$:$c118$ but it does not > work. I think you want $C$3:$C$C118 and $A$3:$A$118. You are getting your $'s in the wrong place. Edit the cell, click on say each range C3:C118, then use F4 to toggle through the various $ options Steve > Let say I have this formula, > =SUMIF('TSJ Student List'!C3:C118,"=4",'TSJ Student List'!A3:A118) [quoted text clipped - 4 lines] > not > work. Please guide me. Thanks. It depends on *how* you want the criteria to change. This allows you to enter the criteria in a particular cell, so that it can be changed by manually entering another number in that cell, and you wouldn't need to revise the formula itself. Say the criteria cell is A1, then try this: =SUMIF('TSJ Student List'!C3:C118,A1,'TSJ Student List'!A3:A118) However, if you're going to copy the formula down a column, and you wish for the criteria to increment as the formula is copied down, try this, with the criteria starting at "4", and increasing by "1" as it's copied down: =SUMIF('TSJ Student List'!C$3:C$118,ROWS($1:4),'TSJ Student List'!A$3:A$118)  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Let say I have this formula, > =SUMIF('TSJ Student List'!C3:C118,"=4",'TSJ Student List'!A3:A118) [quoted text clipped - 4 lines] > not > work. Please guide me. Thanks.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.