Trying to enter a formula to sum a colum based on 2 condition

Max of Newnan · Sep 24, 2009

This is the formula IF C2:C60 = C76 AND IF D2

60 = L75 SUM(A2:A60).
How would this be entered

Sean Timmons · Sep 24, 2009

=SUMPRODUCT(--(C2:C60=C76),--(D2

60=L75),A2:A60)

Max of Newnan · Sep 24, 2009

Formula worked perfectly, thanks a million......

Sean Timmons said:
=SUMPRODUCT(--(C2:C60=C76),--(D260=L75),A2:A60)

Sean Timmons · Sep 24, 2009

not a problem! thank you for the feedback!

Max of Newnan said:
Formula worked perfectly, thanks a million......