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.

What's in column J of the 21000-Salaries worksheet?

If they're real dates--just formatted to show mmm-yy, then your formula won't
work.

Are you sure that column E of that same sheet has real numbers in it--not text
values that look like numbers?



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.

--

Dave Peterson

There are several General Ledger templates at the MS Template Gallery

Post the URL for the one you downloaded so's we could have a look.


Gord Dibben MS Excel MVP

On Tue, 8 Jan 2008 12:06:02 -0800, 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.