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

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(D3:D151,"10000")*AND(D3:D151,"<12000")).

--
Message posted via http://www.officekb.com

Justine,

Try

=SUM((D1:D500=10000)*(D1:D13<=12000)*D1:D500)

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

Don Pistulka


"Justine Burn via OfficeKB.com" wrote in message
...
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(D3:D151,"10000")*AND(D3:D151,"<12000")).

--
Message posted via http://www.officekb.com

Assuming you want to include 10000 and 12000,

=SUMIF(D3:D151,"=10000")=SUMIF(D3:D151,"12000")


On Tue, 22 Feb 2005 01:46:58 GMT, "Justine Burn via OfficeKB.com"
wrote:

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(D3:D151,"10000")*AND(D3:D151,"<12000")).

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


On Mon, 21 Feb 2005 20:14:12 -0600, Myrna Larson
wrote:

Assuming you want to include 10000 and 12000,

=SUMIF(D3:D151,"=10000")=SUMIF(D3:D151,"12000 ")


On Tue, 22 Feb 2005 01:46:58 GMT, "Justine Burn via OfficeKB.com"
wrote:

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(D3:D151,"10000")*AND(D3:D151,"<12000")).

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

--
Message posted via http://www.officekb.com