[access-uk] Re: Help with an excel formula please
- From: "Adrien Collins" <adriencollins22160@xxxxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Mon, 20 Jun 2011 18:10:14 +0200
Hi Pele
Ok thanks for this, I have done what I needed it for but
still have to sort out the other parts of my question. It is
easy when you know how. is there a list of useful formulae
anywhere?
Regards
Adrien
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx
[mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Pele West
Sent: Monday, June 20, 2011 4:10 PM
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Help with an excel formula please
Hi Adrien
I can answer the first part of your question, I think.
You can put a formula in Column C
=sum($b$138:b139)
Put this in C139 then copy it to all the columns up to C711.
The $ sign means it will always start adding from B138.
As for totalling for each month, do you have a column to
show that the month has changed?
Pele West
** To leave the list, click on the immediately-following
link:-
**
[mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on
the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
--
I am using the free version of SPAMfighter.
We are a community of 7 million users fighting spam.
SPAMfighter has removed 15 of my spam emails to date.
Get the free SPAMfighter here:
http://www.spamfighter.com/len
The Professional version does not have this message
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts: