Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
  #2  
Old 02-26-2010, 10:38 AM
FraserKitchell FraserKitchell is offline Moving formula range multiple cells when moving sum over one cell Windows XP Moving formula range multiple cells when moving sum over one cell Office 2007
Novice
Moving formula range multiple cells when moving sum over one cell
 
Join Date: Dec 2009
Posts: 21
FraserKitchell is on a distinguished road
Default

Wow! What a formula! Ok, this is what I was thinking originally. Its going to take me about 2 hours to dissect this one (have to learn about ADDRESS and INDIRECT fxns) Thanks!
Reply With Quote
Reply



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 02:35 PM.


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