Hey.
Im having an issue with a SUMPRODUCT forumla that i just cant get to work.
i have no real skills in Excel (working on excel 2010) and everything i write comes from alot of googling and trial and error. Usually i can find the answer after some time looking. But today i spent half the day trying to figure this one out with no success.
I migh even be completly off on what formula to use.
Im gonna create a spredsheet to help myself and some other local bowlers keep track of some stats during the season that official record doesnt track.
I have a xml file that i have imported into excel (second picture).
And for now im just sorting the data before making it look pretty later.
I can find the amount of "X" (strikes), Spares (/) etc easy but when im trying to count the amount of Splits i have an issue.
These are recorded as "TRUE" or "FALSE" from the xml file with a weird column header.
It also needs to relate to the players multiple "ids".
So it need to be a search that can count the amount of "TRUE" from alle the colums that ends with "*Split" where the full name of the column is "/Frames/Frame9Split" AND match the players ID.
I get the formula to work fine as long as i exclude the second part (with the *Split condition). But this isnt good enough because it counts all "TRUE's" with include Fouls and frames manually edited by the staff when the machine **** up.
I included as much info as i could in the screenshots and i hope this is enough for some person in here to help me out on this
Im having an issue with a SUMPRODUCT forumla that i just cant get to work.
i have no real skills in Excel (working on excel 2010) and everything i write comes from alot of googling and trial and error. Usually i can find the answer after some time looking. But today i spent half the day trying to figure this one out with no success.
I migh even be completly off on what formula to use.
Im gonna create a spredsheet to help myself and some other local bowlers keep track of some stats during the season that official record doesnt track.
I have a xml file that i have imported into excel (second picture).
And for now im just sorting the data before making it look pretty later.
I can find the amount of "X" (strikes), Spares (/) etc easy but when im trying to count the amount of Splits i have an issue.
These are recorded as "TRUE" or "FALSE" from the xml file with a weird column header.
It also needs to relate to the players multiple "ids".
So it need to be a search that can count the amount of "TRUE" from alle the colums that ends with "*Split" where the full name of the column is "/Frames/Frame9Split" AND match the players ID.
I get the formula to work fine as long as i exclude the second part (with the *Split condition). But this isnt good enough because it counts all "TRUE's" with include Fouls and frames manually edited by the staff when the machine **** up.
I included as much info as i could in the screenshots and i hope this is enough for some person in here to help me out on this
