Formulas
I'm trying to create a formula that adds a column and then divides its total
by 60? Simple you would think but I cant get anything to work. Help! |
Formulas
=SUM(A:A)/60
-- Regards, Peo Sjoblom "Chrisj20" wrote in message ... I'm trying to create a formula that adds a column and then divides its total by 60? Simple you would think but I cant get anything to work. Help! |
Formulas
Let's assume you want to add cells A1 through A50. Use this formula:
=sum(a1:a50)/60 "Chrisj20" wrote: I'm trying to create a formula that adds a column and then divides its total by 60? Simple you would think but I cant get anything to work. Help! |
Formulas
Hi Elkar,
Here is a variation that allows you to insert rows anywhere below A2 and above A71, including the immediately above the row with the formulas, without having to change the formula. A61: =SUM(A2:OFFSET(A71,-1,0)) instead of =SUM(A2:A70) Read more about use and need for OFFSET at http://www.mvps.org/dmcritchie/excel/offset.htm If you are simply trying to get the average of sixty items more less you might look instead to the AVERAGE Worksheet Function. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Elkar" wrote in message ... Let's assume you want to add cells A1 through A50. Use this formula: =sum(a1:a50)/60 "Chrisj20" wrote: I'm trying to create a formula that adds a column and then divides its total by 60? Simple you would think but I cant get anything to work. Help! |
All times are GMT +1. The time now is 02:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com