Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I just downloaded a beautiful general ledger template from the MS website.
(http://office.microsoft.com/en-us/te...CT101441121033) It does exactly what I need; however, there is one formula that I don't understand. On the "monthly" tab, there is the following: =SUMIF(Office[Constructed Key Field],"="&(TEXT(Expenses[[#Headers],[Jan-07]],"mmm-yy")),Office[Amount of Check]) I cannot for the life of me figure out where they get "Office" at the very beginning. It isn't pulling from another sheet because that would name it 'Office'! Can anyone help me decipher this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
General ledger spreadsheet | Excel Worksheet Functions | |||
Excel 97 General Ledger | Excel Discussion (Misc queries) | |||
Excel Formulas in General Ledger | Excel Worksheet Functions | |||
General Ledger Template | Excel Worksheet Functions | |||
Excel General Ledger | Excel Discussion (Misc queries) |