[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 15:09:46 +0100
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
Other related posts:
