I would like to find the occurances of a variable based on another variable in a different column.
F Fustrated Feb 9, 2005 #1 I would like to find the occurances of a variable based on another variable in a different column.
D Dave R. Feb 9, 2005 #2 The famous SUMPRODUCT maybe what you're looking for. See here: http://www.xldynamic.com/source/xld.SUMPRODUCT.html#new
The famous SUMPRODUCT maybe what you're looking for. See here: http://www.xldynamic.com/source/xld.SUMPRODUCT.html#new
