uk.sci.weather (UK Weather) (uk.sci.weather) For the discussion of daily weather events, chiefly affecting the UK and adjacent parts of Europe, both past and predicted. The discussion is open to all, but contributions on a practical scientific level are encouraged.

 
 
LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Old November 29th 10, 12:28 PM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Oct 2005
Posts: 3,301
Default (OT) Excel help

Hi, All,
I know this is OT but it is a weather spreadsheet I'm working on, so
can anyone help, please?
I'm quite new to Excel having used works most of the time.
If I set up a formula, for ease I'll say the sum of a row for instance
=SUM(A1:A19) and just fill in the first 5 readings to A5 it does it OK
but any subsequent readings are not automatically added and I have to
click on the results square and enter each time.
Is there a way that the formula should update automatically? I've got
lots on my Met sheet that have to be refreshed each day.
It worked fine in works.
Thanks in anticipation,
Ken
Copley
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel template for recording daily local weather. chipshop uk.sci.weather (UK Weather) 2 September 6th 11 03:29 PM
[OT] Excel help Keith (Southend) uk.sci.weather (UK Weather) 15 March 18th 08 10:59 PM
OT Excel ? Keith (Southend) uk.sci.weather (UK Weather) 5 October 20th 07 07:26 AM
O/T Excel Help Keith (Southend) uk.sci.weather (UK Weather) 9 February 20th 05 06:50 AM
Excel help :-) Keith (Southend) uk.sci.weather (UK Weather) 4 February 29th 04 06:21 PM


All times are GMT. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 Weather Banter.
The comments are property of their posters.
 

About Us

"It's about Weather"

 

Copyright © 2017