Hi,
I need to formula which will only bring back 1, if Status = Pending or Tba, and Urgency is high or Very high.
i've tried countif(data...)+countif(data....) - but it don't work
I've tried :
IF(AND(
IF(OR(
But i'm struggling....any ideas ppl?
cheers
Bookmarks