Help with Formula,reulsts show in Function, not in Spreadsheet?
For the sum try:
=SUMIF(Gume,"21",Dent) and for the average maybe: =SUMIF(Gume,"21",Dent)/COUNTIF(Gume,"21") Hope this helps Rowan Deb Pingel wrote: I am tryin to do a calculation between 2 columns. If the value in column 1 is 21, then I want to Average the corresponding values in Column 2. I have the formula =SUM(IF(Gume21,Dent))where column 1 is named Gume and Column 2 is 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 the Average. Help! Why doesn't my formula work? I have the values listed that I am supposed to get, but the zeroes are what I am getting. |
Help with Formula,reulsts show in Function, not in Spreadsheet?
I am tryin to do a calculation between 2 columns. If the value in column 1 is 21, then I want to Average the corresponding values in Column 2. I have the formula =SUM(IF(Gume21,Dent))where column 1 is named Gume and Column 2 is 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 the Average. Help! Why doesn't my formula work? I have the values listed that I am supposed to get, but the zeroes are what I am getting. -- Deb Pingel ------------------------------------------------------------------------ Deb Pingel's Profile: http://www.excelforum.com/member.php...o&userid=20119 View this thread: http://www.excelforum.com/showthread...hreadid=494042 |
All times are GMT +1. The time now is 10:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com