Hi Don,

Don Guillett wrote:
shouldn't a simple =COUNTIF( do it for you?

I don't get the expected results using a simple =COUNTIF. Could you,
possibly provide an example based on:

Dynamic Named Range "Results" spans 5 Columns and many Rows. Each cell
houses numeric single-digit or double-digit values.

I would like a Formula to find / match all instances of any two particular
numbers (single-digit / double-digit) in the same Row and Sum the Count of
their total occurrences together. For instance, how many times, if any, does
80 and 87 appear together in the same Row. I would like to refer to the
values using two cell references.

Much appreciated.
Cheers,
Sam

Don Guillett wrote:
shouldn't a simple =COUNTIF( do it for you?

Hi All,

[quoted text clipped - 9 lines]
Thanks
Sam


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200509/1