As you can see the from the attached sheet, I have some data in a table is it possible for it to automatically go in a list below with the totals for each person?
Its hard to explain. its easier to see?
As you can see the from the attached sheet, I have some data in a table is it possible for it to automatically go in a list below with the totals for each person?
Its hard to explain. its easier to see?
Formula to get the unique namesFormula to sum them up:Please Login or Register to view this content.
Please Login or Register to view this content.
Click the * to say thanks.
The second one
SUMPRODUCT($d$3:$d$14,--($B$3:$B$14=B22))+SUMPRODUCT($i$3:$i$14,--($G$3:$G$14=B22))+SUMPRODUCT($n$3:$n$14,--($L$3:$L$14=B22))+SUMPRODUCT($s$3:$s$14,--($Q$3:$Q$14=B22))
You data set up is really messy. You should add it in a 6 way column ,starting in A1, range like: #,Name,Rounders,Outs,Date, and whatever is in C1 or I1, or O1,or the other ones.
Then you can use a simple formula to return all the unique names from B column, let's say that you add it in H2(H1 -Unique names): =IFERROR(INDEX($B$2:$B$100,MATCH(0,INDEX(COUNTIF($H$1:H1,$B$2:$B$100),0,0),0)),"")
And 2 SUMIF formulas for Rounders and Outs.
With so many tables, the formulas posted in post #2 will work, but will contain too many SUMPRODUCTs and LOOKUPs
Right I am confused no good at excel for this stuff,
basically each team plays 10 games, and the first column is the batting order, 2nd is rounders scored and 3rd is outs. These are sorted from the other sheets in the table that relay the results to that page.
Could you show me what you mean on my spreadsheet?
But is they no way I can use the layout how it is now? Only because if I change that sheet I would need to change ALL my other formulas across 30 tabs
Upload a sample containing the data layout as it is in your file with some tabs to have a view. I think that what you ask can be done without using the data from this tables, and instead using the data from your raw data.
Sorry didn see your reply I ahve uploaded but this is all based in google sheets as it allows multiple people to edit at the same time but i think its same layot
Paul,
Last time you sorted this out for me I have changed all my data around, but now cant get the fomulas to work, can you show me what formulas I need to make a list of unique values underneath top scorer and then a list of their total scores please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks