Formula to return count of value entered

I want a formula that will return a count value for the number of occurances when a variable is typed in to the cell adjacent.
I have attached an spreadsheet as an example. If I enter a combination of numbers in cell H4 from cloumn H (always first) and column I the formula in cell I4 will tell me how many times that combination appears between the 2 columns.

In I4:

in your example, if you want a count of the 13's in column H and a count of 2's in column I, use this formula. returns 7-33
=COUNTIF($H$8:$H$100000,LEFT(H4,FIND("-",H4)-1))&"-"&COUNTIF($I$8:$I$100000,RIGHT(H4,LEN(H4)-FIND("-",H4)))

If you want a count of 13's in BOTH columns, and a count of 2's in BOTH columns, use this formula: returns 7-45
=COUNTIF($H$8:$I$99999,LEFT(H4,FIND("-",H4)-1))&"-"&COUNTIF($H$8:$I$100000,RIGHT(H4,LEN(H4)-FIND("-",H4)))

or, did you want a count of how many times 13 appears in H AND next to it in column I there is a 2?

it wasn't clear which one u wanted...

does this help?

I want the last answer. If I enter 13-2 how many times doesa that combination appear btween H & I. If I enter 6-4... how many times etc.

Originally Posted by eberns65

I want the last answer. If I enter 13-2 how many times doesa that combination appear btween H & I. If I enter 6-4... how many times etc.

sorry, i dint understand this from your original post. here is the correct one:

=COUNTIFS($H$8:$H$100000,LEFT(H4,FIND("-",H4)-1),$I$8:$I$100000,RIGHT(H4,LEN(H4)-FIND("-",H4)))