Just wondering if there is a formula to count the times a particular colour occurs in a column. I know I could do a filter to count each time, but was wondering if there was a formula I could put at the end of the column/data column to count each occurrence of colour, to make it more permanent and not have to do the filter process each time for each region.
Basically it would total the number of customers in a region, with black/red inactive customers who would not be counted in the list, disregarding the cell value.
I've attached an example spreadsheet of what I'm hoping to accomplish.
*edit changed row to column*
Bookmarks