CountCcolor and COUNTIF(S)

Hi,

I am a CountCcolour, but I need to only have it run if a range of cells equal a number. Is that possible with countif(s)?

The example is;

Column of week numbers
Column of data highlighted various colours

I want to count the colours, but only if it relates to data from a specific range.

My CountCcolour is working fine with this; =CountCcolor('TAB1'!$P$1:$P$2000,Colours!A1)

So I had assumed something like this might work, but it doesn't! ; =COUNTIFS('TAB1'!F1:$F$2000, "=21") =CountCcolor('TAB1'!$P$1:$P$2000,Colours!A1)

(F being the week numbers and P being the coloured column)

Any help out there please?

Thanks a lot, that's a really good work around.

I would like to update if the colour is changed, but this seem to only update once when the formula is added. Is that right?

Ctrl-Alt-Shift-F9 has done the trick. Just need to train my fingers now!

Really appreciate your help with the solution.