General Ledger Template

C

Cyndi

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel General Ledger Template 2
Inserting Lines Makes Formula Inactive 7
Using conditional on ledger data 4
Accounting Functions - List box 0
general ledger 1
Make a sheet for one year? 0
Formula Question... 4
How to 'Automatic Post' Accounting? 0

Top