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

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



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