Thread: Trying to enter a formula to sum a colum based on 2 condition
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
  
Posts: 1,696
Default Trying to enter a formula to sum a colum based on 2 condition
=SUMPRODUCT(--(C2:C60=C76),--(D2:D60=L75),A2:A60)

"Max of Newnan" wrote:

This is the formula IF C2:C60 = C76 AND IF D2:D60 = L75 SUM(A2:A60).
How would this be entered
Reply With QuoteReply With Quote