Hi,

I'm trying to get a traffic-light report to count the number of learners I
have on each of our contracts by their assigned traffic light status, but
it's not working :(

I've written this formula to count the number of learners with a traff-light
status of "red" AND the contract stating "learning world" but it's not
working.

=COUNT(IF((LEARNERS!C6:C299="RED")*(LEARNERS!D6:D2 99="LEARNING WORLD"),1))

Does anybody know why please?

Thanks in advance,

Mike