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?
Bookmarks