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?
I was thinking pivot table or something BUT that is just not working I don't know why but it just scatters it..
!HELP! Still unsolved
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 "--"
Last edited by ChemistB; 11-06-2015 at 06:50 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
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
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 columnsOriginally 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
Last edited by michaelDDW; 11-06-2015 at 08:12 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks