Can anyone help a newbie?
I am trying to count the number of records that match two criteria as follows:
=SUM(IF(ORB!F10:F900="Super critical",IF(ORB!O10:O900="DLARA",1,0)))
This works fine, however I would like to use a wildcard for "DLARA" as such "*ARA", but sadly it doesn't like that much. Does anyone have any sugestions?
Thank you in advance.
Mark
I am trying to count the number of records that match two criteria as follows:
=SUM(IF(ORB!F10:F900="Super critical",IF(ORB!O10:O900="DLARA",1,0)))
This works fine, however I would like to use a wildcard for "DLARA" as such "*ARA", but sadly it doesn't like that much. Does anyone have any sugestions?
Thank you in advance.
Mark
