sumproduct by criteria, month, & year
Column B = mmm/yy
Column C = Quanitity
Column D = Criteria (nameA, nameB)
I would like to sum column C for all quantities which match citeria in D
(nameA) for a certain month and year (Dec, 2007). I tried unsuccessfully to
use an IF statement for column D and a sumproduct for the remainder of the
formula criteria. Any assistance would be much appreciated.
|