How do you use countif for several column criteria?

[Fustrated]

I would like to find the occurances of a variable based on another variable
in a different column.

 

[Dave R.]

The famous SUMPRODUCT maybe what you're looking for. See here:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html#new