I am tryin to do a calculation between 2 columns. If the value in colum
1 is >21, then I want to Average the corresponding values in Column 2.
have the formula
=SUM(IF(Gume>21,Dent))where column 1 is named Gume and Column 2 i
named Dent. I get the correct results for the sum in the Function box
but it shows 0 in the cell on my spreadsheet.
Date    Gume    Dent                   
Dec 2,2005    23    0.45                   
Dec 1,2005    22    0.42                >21   
Dec 5,2005    22    0.4                   
Dec 6,2005    21    0.35                21.8    avg Gume
Dec 10,2005    21    0.35                0.394    avg Dent
Dec 3,2005    19    0.46            0       
Dec 4,2005    18.5    0.41                1.27   
Dec 7,2005    17    0.4            0    109   
Dec 8,2005    16    0.38                0.398   
Dec 9,2005    15    0.36   
I am trying to get the sum first, before I change the formula to th
Average.
Help! Why doesn't my formula work?
I have the values listed that I am supposed to get, but the zeroes ar
what I am getting