ExcelBanter - General Ledger Template

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - General Ledger Template (https://www.excelbanter.com/excel-worksheet-functions/172193-general-ledger-template.html)

cyndi

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.

ryguy7272

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.

All times are GMT +1. The time now is 12:05 PM.