Counting Values Across Columns
=SUMPRODUCT(--(A1:A100=176),--(B1:B100=3415))
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"frankjh19701" wrote in message
...
I have data, numeric values, in mulitple columns and I need to find out
how often values in one column occur with another value in another
column. For example, if in column A there are values 176,2902,331...
and in column B 3134,3415,6345 and so on, but I needed to find find how
often 176 occured with 3415, how would I do that?
--
frankjh19701
|