One way:

=SUMPRODUCT(--(A1:A1000=1),--(D1:D1000=50),--(D1:D1000<=74),
D1:D1000)


In article ,
USChad wrote:

i need a formula to sum the totals in column D that are between 50 and 74
when there is also a "1" in column A. Thanks in advance.