Associate
- Joined
- 15 Jun 2009
- Posts
- 2,494
I currently keep a list of all the concerts/gigs I go to in an Excel worksheet and I'm wondering if theres any formula to count each time I have seen a certain band and put it into a seperate sheet?
Excel Formula Help
- Thread starter UnworthyBean
- Start date
- Joined
- 15 Jun 2009
- Posts
- 2,494
Perfect, Cheers. 
If you want a count for all bands (maybe sorted with the most seen first) then a pivot table. But for just specific bands stick with countif.
Or in the top row of your sheet use the Subtotal function. Then use autofilter on the data. When operating on a filtered list Subtotal sums, counts, averages etc based only on the visible cells.
Or in the top row of your sheet use the Subtotal function. Then use autofilter on the data. When operating on a filtered list Subtotal sums, counts, averages etc based only on the visible cells.