Need help with dragging a formula and changing a reference column as I drag the formula.

		Microsoft Office Forums > Microsoft Excel > Excel
Need help with dragging a formula and changing a reference column as I drag the formula.

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-22-2015, 03:02 PM

macropod

Windows 7 64bit Need help with dragging a formula and changing a reference column as I drag the formula.

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Try:
=AVERAGEIF('Volume Budget'!A:A,'Margin Projections'!$A$1,(OFFSET('Volume Budget'!A:A,,ROW()-1)))
where the final '1' is equal to your starting row#

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dragging conditional formatting like a formula	sjp1966	Excel	9	04-13-2017 06:01 AM
How to add columns without changing formula	dmac19	Excel	4	04-28-2015 02:27 PM
formula to work from data column	masterdineen	Excel	16	08-09-2012 07:52 AM
Formula not getting copied to entire column	theacegary	Excel	1	11-29-2010 02:18 PM
Cross-reference together with Mathtype formula is not working correct	Santa_Clause	Word	2	02-02-2010 04:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:49 PM.