Hi All,
I have a range (Lets say A1:A4) that has various text and numbers in each cell.
NR: 99921 CR
REQ: 21999 CR
REQ: 38383
NR: 38383
I'm trying to do a countif formula that counts how many for "REQ:" AND "CR" in the same cell. I don't want to count ones with just "REQ" or just "CR" but must have both.
Thanks,
Bookmarks