Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Moving formula range multiple cells when moving sum over one cell Moving formula range multiple cells when moving sum over one cell
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 02-26-2010, 12:26 AM
BjornS BjornS is offline Moving formula range multiple cells when moving sum over one cell Windows Vista Moving formula range multiple cells when moving sum over one cell Office 2003
Competent Performer
  
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default
Hi,
I couldn't resist that challenge! I attach solution number 4 (hopefully the last) with a general formula.

The number 3 in the formula (twice) is number of lines skipped. The number 10 in the formula (twice) is the first row with data to sum.

Kind regards
Bjorn
Attached Files
File Type: xls Temperatures_by_quarter_General_formula.xls (28.0 KB, 35 views)
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving formula range multiple cells when moving sum over one cell Moving a Long Document clpix Word 1 01-14-2010 08:55 PM
Moving Entire Text Sleeper Word 2 01-10-2010 04:40 PM
Moving from Vista to Windows 7 zyzzyva57 Office 0 12-18-2009 04:41 PM
Moving formula range multiple cells when moving sum over one cell Range Formula aleksandr Excel 10 05-18-2009 12:14 PM
Moving Items windsurfer Outlook 0 12-06-2005 06:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:47 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft