Thank you STDEV(i)!. $B$3:B3 is what was needed to lock it. Formula works in column C as well. Double fixed!! J
~Susan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of STDEV(i) Sent: Friday, March 11, 2011 11:17 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula that will add on next cell's data Hi Susan, Formula in cell D3 sheet Apr 2011 =SUM('Mar 2011'!$B$38,$B$3:B3)/E3 and then drag it down see examples in sheets Jan upto Apr 2011 On Sat, Mar 12, 2011 at 2:50 AM, Susan 1 <sunni...@gmail.com> wrote: > Hi, > > =('Mar 2011'!$B$38+B3+B4+B5+B6+B7)/E7 > > can you please show me how I can change the above formula to add on the next > cell's amount , so I don't have to add in B3 each time. I tried adding in > $B$3 but the formula changes and deletes $B$3 and addes $ to B4. Would be > quicker for me if I had one formula and just grabbed the copy indicator and > pulled it down the column. > > See the attached file. The formula is in column D cells, someone else > enters data in column B cells. But before that person can enter in data in > column b cells I need to have the formula in column D cells add on the next > preceeding cell down in the formula. > > This formula will be used in all exisiting tabs. > > I tried the +1 formula but that didn't work. > > Any help would be appreciated! :-) > > ~Susan -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel