Help with Formula,reulsts show in Function, not in Spreadsheet?

R

Rowan Drummond

For the sum try:
=SUMIF(Gume,">21",Dent)

and for the average maybe:
=SUMIF(Gume,">21",Dent)/COUNTIF(Gume,">21")

Hope this helps
Rowan
 
D

Deb Pingel

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
 
Top