ExcelBanter - Sum between two numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum between two numbers (https://www.excelbanter.com/excel-discussion-misc-queries/27317-sum-between-two-numbers.html)

USChad

Sum between two numbers

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.

JE McGimpsey

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.

All times are GMT +1. The time now is 11:41 AM.