[access-uk] Re: Help with an excel formula please
- From: "Pele West" <pele.west@xxxxxxxxxxxxxxx>
- To: "access-uk@xxxxxxxxxxxxx" <access-uk@xxxxxxxxxxxxx>
- Date: Mon, 20 Jun 2011 23:01:32 +0100
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
Other related posts: