Adding the sum of figures in one column if they meet 2 criteria

[Justine Burn via OfficeKB.com]

Please help! I have a column of 500 figures. I want to calculate the total
value of all figurews between 10000 and 12000 in the column at the bottom
of the page. What do you recommend? Currently i have the following but it
is not working. =SUM(IF(D3151,">10000")*AND(D3151,"<12000")).

 

[Don]

Justine,

Try

=SUM((D1500>=10000)*(D113<=12000)*D1500)

Entered as an array formula (ctrl-shift-enter)

Don Pistulka

 

[Myrna Larson]

Assuming you want to include 10000 and 12000,

=SUMIF(D3151,">=10000")=SUMIF(D3151,">12000")

 

[Myrna Larson]

Typo there: WRT the 2nd SUMIF, it should be -SUMIF(....) rather than
=SUMIF(....

 

[Justine Burn via OfficeKB.com]

Thank you thank you thank you. Fab Myra. Owe u big time.