I would like to create an excel formula which counts the number of cells in a column which are a specific color. an example of this:
I would like the cell B2 to count the number of enquiries which appear in a separate worksheet (Region 1) which match the colour of cell A2. I would like the cell B3 to count the number of enquiries which appear in the region 1 worksheet which match the colour of cell A3 and so on. I would also like to apply this for column C for the region 2 worksheet etc.
Is there an excel formula which will count the cells in the separate worksheet which match the colour of the specific cell and count them?
Thanks, much appreciated if anyone can help.
I would like the cell B2 to count the number of enquiries which appear in a separate worksheet (Region 1) which match the colour of cell A2. I would like the cell B3 to count the number of enquiries which appear in the region 1 worksheet which match the colour of cell A3 and so on. I would also like to apply this for column C for the region 2 worksheet etc.
Is there an excel formula which will count the cells in the separate worksheet which match the colour of the specific cell and count them?
Thanks, much appreciated if anyone can help.