View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric M. Eric M. is offline
external usenet poster
 
Posts: 2
Default 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.