I cant get my Sum(Offset formula to pull appropriate data.

		Microsoft Office Forums > Microsoft Excel > Excel
I cant get my Sum(Offset formula to pull appropriate data.

FAQ

Mark Forums Read

Thread Tools

Display Modes

07-28-2016, 11:14 AM

xor

Windows 10 I cant get my Sum(Offset formula to pull appropriate data.

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

I don't understand your logic.

Breakeven!F4 = 1

Sales!B19 = 1000

Breakeven!B19 = 2000

and
If we change Breakeven!F4 to 5

Breakeven!F4 = 5

Sales!B19 = 1000

Breakeven!B19 = 5000

1: 2000
2: 3000
3: 4000
4: 5000
5: 6000

or what is the pattern?

Perhaps like the attached.

Attached Files

Breakeven Lyte_2.xlsx (22.2 KB, 10 views)

« 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
pull data using drop down menu	nfsmith	Excel	8	03-23-2016 11:28 PM
Data validation list filter with range defined by OFFSET	Mango123	Excel	4	03-18-2014 02:52 PM
Syntax to use OFFSET() in a cell formula?	dlowrey	Excel	3	07-09-2013 09:15 AM
sumproduct formula to pull info from multiple sheets	Berk21	Excel	7	01-15-2012 11:41 AM
Excel VBA: Pull data from web	tinfanide	Excel Programming	0	12-09-2011 02:11 AM

Other Forums: Access Forums

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