I am not sure I understand you? Do you mean like this
=SUM(COUNTIF(Range1,{1;3}))
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
"Will" wrote in message
...
Hi,
I have a project to count how freq a pair of numbers appear amount A FEW
groups of 6 numbers.
Lets say I have 2 pairs of 6 numbers, (1,2,3,4,5,6) & (1,3,5,7,9) and
pairs
(1,3) & (3,5) & (1,5) appears twice in these 2 pairs of 6 numbers. I am
unable to
find a suitable formula for this problem and the nearest I can do is
COUNTIF
but COUNTIF can only cater 1 CRITERIA but in these i believe I have 2 or
more.