Thread: general ledger
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lktx lktx is offline
external usenet poster
 
Posts: 10
Default general ledger

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.