[access-uk] Re: Help with an excel formula please
- From: "Adrien Collins" <adriencollins22160@xxxxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Wed, 22 Jun 2011 15:43:21 +0200
Hi Pele
Don't worry, your formula worked for me. Thanks. It is
always hard understanding something if you haven't done it
before. Take care.
Regards
Adrien
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx
[mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Pele West
Sent: Tuesday, June 21, 2011 12:02 AM
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Help with an excel formula please
Hi Adrien
I am not sure I understand your question. If you put the
formula in C139 using $b$138 as your starting point, it
should work.
If, at the start of each month, you put a formula in, say
Column D, you should be able to total the figures for that
month. For example, suppose your figures for June started
in Column B400. When you entered the
second amount in Column B401 put a formula in D401:
=sum($d$400:d401)
and copy it to all the rows for that month.
I don't know if there is a list of useful formulae anywhere.
I spend quite a lot of time using Google to find out what I
want to know.
Pele
** 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 27 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:
