Adding stats to the TOTALS tab. (WEEK1 thru WEEK8)
Getting the PLAYER from the WEEK1 tab, then using INDEX/MATCH to find him on the other tabs and pulling in his stats from those tabs.
Works GREAT for MOST players, but some getting the N/A error starting on WEEK7.
TESTED: Tried pulling in just ONE week (WEEK6), worked great on ALL players
Changed to just pull in just WEEK7, got the N/A on Kaepernick and Rodgers.
Question: Why are Kaepernick and Rodgers getting errors on week7?
Last edited by x65140; 04-17-2014 at 07:42 AM.
Hi - Kaepernick and Rodgers get errors on weeks 7 and 8 because on all the other sheets they have a space after their name. So you are trying to match the name with a space after it which is picked up from the week1 table to the ones without a space in weeks 7/8. If you add the space to week 7/8 your formulas should work.
Wow! Nice catch - Thanks! Thought I was going nuts - you saved me a fortune on therapist fees!
Works great now!
In E3 Cell
=SUMPRODUCT(--SUMIFS(INDIRECT("'"&$H$2:$O$2&"'!E:E"),INDIRECT("'"&$H$2:$O$2&"'!C:C"),$C3,INDIRECT("'"&$H$2:$O$2&"'!D:D"),$D3))
Drag it down....
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
You might also be better putting the sheetnames in A3:A10 and using a formula like:
=SUMPRODUCT(SUMIF(INDIRECT("'"&A$3:A$10&"'!$C3:C10"),C3,INDIRECT("'"&A$3:A$10&"'!E3:E10")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
x65140 
Register To Reply
Bookmarks