Hi,

I've not heard of the countbycolor function and my Excel doesn't
recognise it - but I am guessing that if you used the function

= COUNT(G12:G66)/(((countbycolor(G5:G65,
46,FALSE))+(countbycolor($A$5:$A$65,40,FALSE)))

it should achieve what you want?

What is the function used for by the way? Is it an addin?

Regards

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=566081