Count occurances Problem
I have a range a1:a150 that can contain"rx" and could possibly contain
"rx(2)" which means there are 2 "rx" at location. Note: The same field can
have "rx,dx,sx" or "rx(2),dx,sx(4)", etc.
I want to count the occurrences when a1:a150 contains "rx" and add to count
by whatever is included in parentheses.
For example if a1-a5 contains "rx(2),sx" and a6-a10 contains "rx,dx" the
value of formula should return 15 because. I need to allow for multple
values per cell so I can do similar calcs based on different values
separated by commas.
Thanks in advance.
|