# HELP! formula to transfer data and place in proper location month2month..c attached

1. ## HELP! formula to transfer data and place in proper location month2month..c attached

So I am trying to get my sheet2 to auto fill from information on sheet 1. If the location is brisbane and the date is 10/01/15 i want the ADD value to appear in the desired location.

I did example for brisbane 10/01/2015 but if you look at a more complex location/date like almost any fresno etc how can i make this auto fill and go month to month?

2. ## Re: HELP! formula to transfer data and place in proper location month2month..c attached

I was thinking pivot table or something BUT that is just not working I don't know why but it just scatters it..

3. ## Re: HELP! formula to transfer data and place in proper location month2month..c attached

!HELP! Still unsolved

4. ## Re: HELP! formula to transfer data and place in proper location month2month..c attached

So for 10/1 and Fresno, would it be an average of all numbers on 10/1 or the Sum? or something else? Are all values taken from the GC column? Does GD column influence any of this?

Assuming SUM, for the first table on sheet2, in B3 Copied and Pasted (Copy and paste, do not drag)

=IFERROR(SUMIFS(Table1[GC],Table1[City],\$A3,Table1[Date], B\$2),"")
(if averaging values, replace SUMIFS with AVERAGEIFS)

I custom formatted the cells for 0's to be "--"

5. ## Re: HELP! formula to transfer data and place in proper location month2month..c attached

I want them to add the SUM

SO Sheet1 Fresno 10/01/2015 has multiple numbers...I want those transfered to sheet2 Fresno 10/01/2015 added up already

Fresno 10/1/2015 1549 0
Fresno 10/1/2015 1483 0
Fresno 10/1/2015 1599 0
Fresno 10/1/2015 991 0

So the designated spot would be 5622

See Post 4

7. ## Re: HELP! formula to transfer data and place in proper location month2month..c attached

Originally Posted by ChemistB
So for 10/1 and Fresno, would it be an average of all numbers on 10/1 or the Sum? or something else? Are all values taken from the GC column? Does GD column influence any of this?

Assuming SUM, for the first table on sheet2, in B3 Copied and Pasted (Copy and paste, do not drag)

=IFERROR(SUMIFS(Table1[GC],Table1[City],\$A3,Table1[Date], B\$2),"")
(if averaging values, replace SUMIFS with AVERAGEIFS)

I custom formatted the cells for 0's to be "--"
OMG thank you! so how can I make this fill for all the dates listed? and then continue monthly? I usually drag the little piece at the bottom right but in this case it is seperated by some rows and columns

8. ## Re: HELP! formula to transfer data and place in proper location month2month..c attached

As I said, Dragging doesn't work when using table references like I did (there are ways but that's another story) So copy B3 into B17, manually change "B\$2" to "B\$16, then copy and paste that into the rest of table 2, repeat for table 3, modifying the references each time.

9. ## Re: HELP! formula to transfer data and place in proper location month2month..c attached

Originally Posted by ChemistB
As I said, Dragging doesn't work when using table references like I did (there are ways but that's another story) So copy B3 into B17, manually change "B\$2" to "B\$16, then copy and paste that into the rest of table 2, repeat for table 3, modifying the references each time.
Not working on my original spreadsheet for some reason. everything is pritty much the same including the table any idea why? Can I send you private message of the original post to show me what you mean? Maybe one of my tables is messing it up or something

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1