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

Thread Tools

Display Modes

07-28-2016, 11:27 AM

Erickd90

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

Office 2016

Novice

Join Date: Jul 2016

Posts: 4

XOR,

The pattern would follow this...

0: 1000
1: 2000
2: 3000
4: 5000
5: 6000

I have used an IF statement to complete everything except I am not sure how to avoid the multiplying by 0...

« Previous Thread | Next Thread »

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 01:07 AM.