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.

Is an image

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.

enter image description here

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

enter image description here

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.

1 Answer 1

  • paste in C19 cell and drag down:

    =COUNTA(IFERROR(FILTER('Repair Jobs'!$G$4:$G, 'Repair Jobs'!$G$4:$G=$B19)))

  • paste in D19 cell and drag down:

    =SUM(IFERROR(FILTER('Repair Jobs'!$F$4:$F, 'Repair Jobs'!$G$4:$G=$B19)))


  • 1
    Thank you very much for yet again helping, Each time I get to learn more things about these sheets. Thank you very much for that.
    – Melk
    Jul 29, 2019 at 5:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.