Hello,
I'm using the following formula to search and return a value and it works, but I need to add another Criteria and I can't figure out how to do this:
=IFERROR(1/(1/COUNTIF($F18:$U18,"*Criteria*")),"0")
Can anyone please help how I can add another or multiple criteria?
Thanks
Bookmarks