Your formula isn't quite right - you have an extra comma and AND.

Try this:
=IF(AND(OR(N13="Pending", N13="Tba"),(OR(M13="High",M13="Very High")),1,"")

Andy.


"harpscardiff"
wrote in message
news:harpscardiff.21senm_1137515100.5747@excelforu m-nospam.com...

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