Hello All
I have a column of data in Col K,I would like to use a formula which will count the data as follows
A.number of cells in red font on blue background
B.number of cells in red font total
C.number of cells in green font on blue background
D.number of cells in green font total
E.number of cells in black font on white background
F.number of cells in black font total
The results for each in sequence to be in Cols b&c rows 1 to 3
eg.Red font cells on blue background = 208
Red font cells total = 673
The formula will then count the numeric data in Cols P&Q relating to each colour combination in Col K and place the results in Cols N&O rows 1 to 3.
eg.Total for red font on blue background in col P =2800
Total for red font on white background in col Q =19514
I have attached a worksheet which i hope will explain,many thanks for help given.
Bookmarks