counting
1 Topic
Count entries on a category omitting duplicates and blank cells
Good afternoon, I hope you can help me I'm working on a spreadsheet of injured players from a football club, I have on column "A" the category of the player, on column "B" the name of the players, and on column "C" the injury. On another sheet I want to have the number of injured players for every category, so I'm looking for a formula that counts the number of players on a especĂfico category, without counting the duplicates and without crashing on blank spaces. The only thing I could come up with is this: {=SUM(IF(FREQUENCY(IF(IS BLANK(injuries!B2:B15)=FALSE(),MATCH(injuries!B2:B15,injuries!B2:B15,0),""),IF(IS BLANK(injuries!B2:B15)=FALSE(),MATCH(injuries!B2:B15,injuries!B2:B15,0),""))>0,1))} Wich I frankly don't really understand how it works, and only counts the total of injured players, I've tried to nest an IF(A2:B15="sub 9",....) But it didn't work. Please kind sirs, I'm in need of your knowledgeSolved7KViews0likes9Comments