Formula question

[Guest]

I am creating a yearly expense sheet with per month each page and a summary
sheet with monthly totals
How can I set it up so when results for monthly totals are created on the
month page they also appear on the yearly summary page?

Thanks in advance

 

[Matthew]

I am creating a yearly expense sheet with per month each page and a summary
sheet with monthly totals
How can I set it up so when results for monthly totals are created on the
month page they also appear on the yearly summary page?

Thanks in advance

Chris,

Make sure each month is in exactly the same format..with a monthly
total in the same cell on each sheet. eg f12

Then Insert a blank sheet at the begining and call it first, after
December and before Summay insert a blank sheet called last.

Then in the summary sheet

=sum(first:last!F12)

This will work for any cell and you can copy and paste it to easily
create a complete summary.


Hope it helps

 

[Bob Phillips]

Just link a cell on the yearly page to it

=Jan!A1

etc.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)