Thread: Need to sum a column if two cells in row are equal
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
  
Posts: 695
Default Need to sum a column if two cells in row are equal
Try:

=SUMPRODUCT((B2:B5=C2:C5)*(D2:D5))
=SUMIF(A2:A5,""&TODAY()-90&"",D2:D5)


Reply With QuoteReply With Quote