AgTalk Home
AgTalk Home
Search Forums | Classifieds | Skins | Language
You are logged in as a guest. ( logon | register )

Excel Question
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
95h
Posted 7/8/2010 14:12 (#1265320 - in reply to #1263105)
Subject: RE: Excel Question, martin has the right idea,


Kittitas Co. Wa. State

You could either have the car pmt. as a running total and/or a yearly total.

Don't need anything fancy, monthly sheet. columns for different expences, date, check #, etc..  monthly sub totals at the bottom of the sheet, sub totals would carry over to the yearly total.

Do a drill down, all 12 months will be exactly the same. 13th sheet will be yearly total.

Can be run vertically or horizontally. Just have to set the code, in the yearly total sheet.

would look like this.     Car payment   =sum (jan:dec! d24)

Not in excel obviously but "car pmt" would be in 1 cell, next cell would have the code. Obviously the code would have different values but what it is saying is "look at all 12 months (jan-dec) and add up the totals in every month from cell D24.

That would give you a running total.    If you want a 12 month pmt to show 12 months of payments..    first cell could be jan, 2nd cell Feb, etc, etc,,  in a column. The next cell would be be coded, "=sum(!Jan !D24)"   down the 2nd column Feb next cell would be "=sum (!feb 1D24

The "!"  is the code to only use the value in "Jan D24"      WHere as "jan:dec!D24"  is saying look at 12 pages and only select the values in D24 and add them up.

Krap,, takes longer to explain it than it would be to lay out the entire Wookbook !!

Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)