Ok,

I have been trying to figure this out but to no avail so any help would be greatly appreciated.

I have a datasheet with 5 columns filled with numerical data. example below:
10 21 22 25 36
6 15 16 24 39
8 15 29 40 46
13 20 30 32 46
1 8 12 42 44
13 19 20 25 42


I am attempting to analize how many times a specific number is populated with another. For example A formula to count how many times the number 42 is populated in the same row with the number 1. Due to the large amount of data that I will be working with I would just like to enter the first value in A:1 and receive the total count in B:1.

Is a countif function the best way to go with this?

Thanks again for any help.