View Single Post
  #1   Report Post  
Justine Burn via OfficeKB.com
 
Posts: n/a
Default 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