I have some rows of numbers that I need to count certain combinations, here
is an example:
2 4 6 8
1 2 4 7
2 3 5 7
1 4 7 9

Say I want to find how many times 2 and 4 occur together (but only if they
occur in the same row) how would I accomplish this? In my example above this
would be 2. I know countif won't do it and I've tried sumproduct, but it's
quite possible I wasn't using it right. Thanks, Dave