We support clients to submit proposals to win public sector contracts. I have a list of clients with an entry per project completed (several clients repeated for multiple projects with us). I have them categorised by their industry. We take notes whenever a client wins their proposal (e.g. Client 1 - Healthcare - 2 wins). I need to know how many wins we've had per industry. The trouble is, if a client is repeated as we've done more than 1 project with them, both entries will show the same win figure in the wins column e.g. (Client 1 - Healthcare - 2 wins / Client 1 - Healthcare - 2 wins) this would obviously sum to 4 wins for this client in the healthcare category when in reality, the 1 client only has 2 wins.
I've tried everything I know + a lot of googling but can't seem to find a way of summing/counting our 'wins' column with an "if" on industry whilst also accounting for the fact that several entries are repeated for the same client.
I've attached an example / redacted workbook with my efforts/attempts etc. so far.
Any help would be much appreciated!
EDIT: I should say - in my actual file, all client and win/loss information is automatically calculated from other sheets. we don't manually record any stats in this sheet. The data here is just an example of how data looks as it automatically comes through
Bookmarks