Thread: Formulas
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default 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!