I need a bit of help on how to create a formula that has been driving me up the wall. I have two columns. I am trying to find the number of occurrences of two different values across two different columns.
Here are my two columns:
Program Causation
7 2
13 3
7 2
16 2
7 2
7 1
13 2
7 3
16 2
13 1
I am trying to calculate how many times program # experiences causation #. So for Program 7 would be 3 occurrences where causation 2 appears. I have about 200 rows of the same numbers to account. I have tried countif and sumif functions. Can anyone please shed some light on my dark day?
Thanks a million!
Bookmarks