Score Analyser

[matrixpom]

Good day all & Happy New Year!

I have a worksheet that I use to put together building inspection reports, each issue I find I give a score or rating (1 to 5), if the issue is severe I score it a rating "1", if not too serious a rating "5" (see Sheet1). In most cases I will have more than one issue found in each building, sometimes as many as 20. Basically I need a formula to look through column "C" & pull out the individual building ID number & calculate how many rating 5's, 4's, 3's, 2's & 1's each building scored from column "G" (Sheet1) & populate this information into the chart on Sheet2. Also this will need to update each time I input a building ID that is unique & add a new line to the chart with the required calculations, hopefully that makes sense? Thank you for any assistance you can give & have a great day - Marco

[FDibbins]

TRy this...
A2=IFERROR(INDEX(Sheet1!$C$2:$C$110,MATCH(0,INDEX(COUNTIF($A$1:A1,Sheet1!$C$2:$C$110),),0)),"")
copied down
B2=IF($A2="","",COUNTIFS(Sheet1!$C:$C,Sheet2!$A2,Sheet1!$G:$G,COLUMN(A1)))
copied down and across as needed

[matrixpom]

Wow...I'm speechless, works perfectly, thank you once again FDibbins, you're a legend! - Marco

[FDibbins]

Thanks for the kind words and feedback