| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
General Ledger Template
Please show the link to the template.
-- RyGuy "Cyndi" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format: General - Text - General | Excel Worksheet Functions | |||
| Is there a general excel small business ledger/journal template? | Excel Discussion (Misc queries) | |||
| Where can I get a general template for T-accounts | Setting up and Configuration of Excel | |||
| how do i set up a purchase ledger | Excel Discussion (Misc queries) | |||
| Excel General Ledger | Excel Discussion (Misc queries) | |||
Hybrid Mode
