Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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")). |
#4
|
|||
|
|||
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")). |
#5
|
|||
|
|||
Thank you thank you thank you. Fab Myra. Owe u big time.
-- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding more than 30 numbers in a column | Excel Worksheet Functions | |||
Adding a KeyID column for sorting | New Users to Excel | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
macro - adding rows to a column that is summed | Excel Discussion (Misc queries) | |||
Adding column data | Excel Worksheet Functions |