Is it possible to count how man wins at a venue in two collums?

Copper Contributor

So I have a spreadsheet and in collum "C" I have 9 venues that I compete at and in collum "D" I have my ranking. I was wondering if it was possible to have a list of the venues and a counter next to it counting how many times I have won at ea

 

Venue 1 - 0

Venue 2 - 1

Venue 3 - 0

Venue 4 - 3

Venue 5 - 5

Venue 6 - 0

Venue 7 - 1

Venue 8 - 1

Venue 9 - 2

3 Replies

@thenewguy87 

 

I was wondering if it was possible to have a list of the venues and a counter next to it counting how many times I have won at ea

 

Of course it's possible, but what we'd need to know, in order to give some ideas as to HOW it's possible, is how your raw data regarding your competitive record is organized. Those numbers won't just magically appear, so where will they come from? Do you track each match, the date, the venue, the result? If not...then, no, it's not possible.

@mathetes 

My apologies for not giving enough info.

 

The way the data is currently entered is just into the collums so then there will be a blank row between dates. I have attached an image as an example to try an show what it looks like.

 

So I guess what I am trying to do is have it so if the vaule in collum D is 1 then it counts the venue?

 

I am sorry, in my head it is clear but I struggle to get my thoughts written down.

 

Date - Game - Venue - Placement - Score

 

example.png

@thenewguy87 

 

Here's a solution that works. It requires that you make use of some tools that probably will be new to you. Arrange your raw data as a table, first of all. Once you've done that, you'll be able to add new events at will and have them counted. Creating a table will mean eliminating those blank rows--helpful for human eyes but an interference to Excel; let Excel work at its best by learning to separate the raw (Input) data from the output end of things.

 

The formula uses the FILTER function, which does require Excel 2021 or newer, so I hope you have that.

 

I've also used Data Validation to make sure that you enter the Pitch (venue) data consistently.

 

All of those hyperlinks above will take you to a resource that explains the method or tool.