need help with formula when dragging down

		Microsoft Office Forums > Microsoft Excel > Excel
need help with formula when dragging down

FAQ

Mark Forums Read

Thread Tools

Display Modes

03-05-2019, 02:55 PM

JVenz0913

Windows 10 need help with formula when dragging down

Office 2019

Novice

Join Date: Mar 2019

Posts: 2

need help with formula when dragging down

I want to have the cell reference change when I copy it down I am working out of Excel Office 365

This is the formula in the cell
=SUM('Annual Invoice Breakdown'!D3

5)

The next formula I want to read
=SUM('Annual Invoice Breakdown'!E3:E5)

Thank you kindly!

« Previous Thread | Next Thread »

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dragging a row changes formatting	BertLady	Word Tables	1	12-01-2018 11:44 PM
Dragging conditional formatting like a formula	sjp1966	Excel	9	04-13-2017 06:01 AM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Dragging cells with filters on	krisjah	Excel	1	01-25-2014 11:08 AM
Dragging Pictures into Placeholders	simville02	Drawing and Graphics	1	09-29-2013 06:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:34 PM.