| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel General Ledger Template
I downloaded a General Ledger Template from Microsoft. It contains a YTD
sheet, A Monthly Sheet ( Sub Totals by General Ledger Account ) and seperate sheets for each General Ledger Account. The formula as written is =SUMIF('21000-Salaries'!$J:$J,"="&(TEXT(C$5,"mmm-yy")),'21000-Salaries'!$E:$E) However the data from 2100-Salaries is not showing up on the monthly sheet. Can anyone help me to make the change or correction. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 97 General Ledger | Excel Discussion (Misc queries) | |||
| General Ledger Template | Excel Worksheet Functions | |||
| General Ledger template from Microsoft website - adding GL categor | Excel Programming | |||
| Is there a general excel small business ledger/journal template? | Excel Discussion (Misc queries) | |||
| Excel General Ledger | Excel Discussion (Misc queries) | |||
Threaded Mode
