U
USChad
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.
when there is also a "1" in column A. Thanks in advance.
J
JE McGimpsey
One way:
=SUMPRODUCT(--(A1:A1000=1),--(D1
1000>=50),--(D11000<=74),
D11000)
=SUMPRODUCT(--(A1:A1000=1),--(D1
1000>=50),--(D11000<=74),D1
1000)