without a doubt that should work. i've changed it to the following:
=IF(AND(OR(N13="Pending",N13="Tba"),AND(OR(M13="Hi gh",M13="Very
High"))),1,"")

But its still not picking anything up?

Sheet 1
Col N is validated so that it has Pending, Closed and TBA
Col M is validated so that it has Low, Medium, high, Very High

Sheet 2
Is a summary page, basically i want a count of all cases pending which
has an urgency of high or very high?


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=502080