Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 04 October 2018
  0 Replies
  1.3K Visits
0
Votes
Undo
First off apologies for the subject line!

Example:

My Cell contains this

O622, Z370, O48X, O680, O700, O679, O681, O418, O268, R030, R80X, G35X, E668, Z833

To count if I have an occurrence of an R code in the range of R00-R99 I use this formula

=SUMPRODUCT(--ISNUMBER(SEARCH("r",G3)))

I do not know how to count if I have an instance of this range A00-B99

Thanks

Linda
There are no replies made for this post yet.