=SUM(((OFFSET(Sheet1!H$9:H$20,,MATCH(A1,Sheet1!I$5:$NI$5,0),,7)="2")*(NOT(ISNUMBER(OFFSET(Sheet1!H$9:H$20,,MATCH(A1,Sheet1!I$5:$NI$5,0),,7))))),((OFFSET(Sheet1!H$9:H$20,,MATCH(A1,Sheet1!I$5:$NI$5,0),,7)="1")*(NOT(ISNUMBER(OFFSET(Sheet1!H$9:H$20,,MATCH(A1,Sheet1!I$5:$NI$5,0),,7))))),((OFFSET(Sheet1!H$9:H$20,,MATCH(A1,Sheet1!I$5:$NI$5,0),,7)="3")*(NOT(ISNUMBER(OFFSET(Sheet1!H$9:H$20,,MATCH(A1,Sheet1!I$5:$NI$5,0),,7))))),((OFFSET(Sheet1!H$9:H$20,,MATCH(A1,Sheet1!I$5:$NI$5,0),,7)="-")*(NOT(ISNUMBER(OFFSET(Sheet1!H$9:H$20,,MATCH(A1,Sheet1!I$5:$NI$5,0),,7))))),((OFFSET(Sheet1!H$9:H$20,,MATCH(A1,Sheet1!I$5:$NI$5,0),,7)="G")*(NOT(ISNUMBER(OFFSET(Sheet1!H$9:H$20,,MATCH(A1,Sheet1!I$5:$NI$5,0),,7))))))
The formula lists one by one which characters you would like to include in your counting.
Bookmarks