The concat idea worked. Thank you very much!
--
Rob K


"loudfish" wrote:

On 9 May, 23:30, Rob K wrote:
But I can't seem to further restrict the count to just 'data' and
'medium'. I've tried the If-And function without sucess.

Thanks in advance
--
Rob K

Col A.........ColB
Category....Priority

Add ColC
=A1&B1

This will concatenate the two values together. Copy this formula down.

Now you can COUNTIF... using 'datamedium'

HTH

Andrew