Forum Discussion
Is it possible to count how man wins at a venue in two collums?
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 ...
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
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.
