r/sheets • u/tateboyo • 3d ago
Request Counting Subscriber for Comic Shop
Hi! First time posting here! I work at a local comic shop and we're trying to streamline the process by which we count subscribed customers to certain ongoing series. We have a sheet that has the title of the series and the subscriber. I want to create a sheet that tells me how many of each title to order, basically a sheet that counts how many cells for "Batman" or "Spider-Man" there are etc. I've been trying out various countif functions, but they don't really work for this because I need something that will just automatically add a new title to the counts, rather than making me count each individual title by name.
I've added a copy of what the sheet looks like.


