Sumproduct(countif(keeps counting empty cells that have a formula in them.... ?

I think you forgot to attach the sample file.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button), as it doesn't work on this forum.

Hope this helps.

Pete

Yeah, it keeps saying upload failed.....Lol.....Ugh! I'm working on it...

So I attached a screen shot.... Maybe that will help to see the cells I am battling...??

=if(u3=true,"",o3)

Maybe I should just tell you what i am trying to do and you have a better way to make it happen.....

1. I want to be able to count how many occurrences of two digits appear in cells F3 thru H23 BUT (not include cells that have a duplicate in the same cell (ex: G5, F7, etc.)

2. Then use a Rank function to show the results of the pairs of numbers that occurred the most (Ranked #1), then second most occurred pairs (Ranked #2) and so on as shown in columns
Y thru AA as shown in the screen shot.

3. It would be really cool to be able to also fix the cell formula in column U as they actually counting the matching cells more than once. The formula in U6 for example
(=SUMPRODUCT(COUNTIF($J$3:$L$23,J6)) is saying cell J6 which has the number 79 appeared three times in column J which is true but when you go down the list in column U, you
will notice U10 and U23 are displaying the same result (number 79 appearing three times in column J). That is screwing up the Rank function, making it in-accurate in columns Y thru AA