So with my sheet, I am currently in the process of adding more stats in, I have looked into adding these stats by using Index & Match however it will only match to the first correct match it has not all.
So pretty much I am trying to get stat sheet filled by having it turn the corresponding colors in my KEY into their respective types. So the red in the below photo will condense into the red in the above photo.
I tried doing this by copying all the cars in the key below the main stats I want and making individual stat sheets per category then using a =SUM to make the final sheet
I will attach the Spreadsheet HERE, I will attempt to answer questions if asked but I need to sleep after spending too much time trying to figure this out. I am new to all this so any help is appreciated, thank you very much.