Need the correct formula
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
|