software

I’m building a general ledger. I’m about 80% complete and need to now
move into the final 2 pages (1. YTD Budget Summary which will pull from
the 2. roll-up page).

I built the following formula;

=SUMIF('AP-24X7'!$P:$P,quot;=quot;amp;(TEXT(C$5,quot;mmm-yyquot;)),'SP-24X7'!$L:$L)

It seemed to work at first, but I quickly realized that it was not
pulling information exclusive to both the date and to mthe object code.
It would put the amounts that were exclusive to only the date in all
the corresponding month columns across all of the object codes whether
it was exclusive to that object code or not.

What I'm trying to do is;
Build a general ledger with multiple tabs that refer to 14 different
cost centers. Each of the cost centers spend from 63 different quot;Object
Codesquot; for Example 56200. I need to pull together into a roll-up page
the summary of all expenses on a monthly basis spent in each object
code, by each of the cost centers (A Net Roll-Up).

So ultimately I need to construct a formula that will go to all 14
worksheets look for exclusive data that refers to the date and also the
object code (ie. 56200), and return the data back to my designated
roll-up page.

Can someone assist me?

Thank you in advance!--
My2Boyz9802
------------------------------------------------------------------------
My2Boyz9802's Profile: www.excelforum.com/member.php...oamp;userid=33704
View this thread: www.excelforum.com/showthread...hreadid=534954See previous post.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;My2Boyz9802quot; gt;
wrote in message
...
gt;
gt; I'm building a general ledger. I'm about 80% complete and need to now
gt; move into the final 2 pages (1. YTD Budget Summary which will pull from
gt; the 2. roll-up page).
gt;
gt; I built the following formula;
gt;
gt; =SUMIF('AP-24X7'!$P:$P,quot;=quot;amp;(TEXT(C$5,quot;mmm-yyquot;)),'SP-24X7'!$L:$L)
gt;
gt; It seemed to work at first, but I quickly realized that it was not
gt; pulling information exclusive to both the date and to mthe object code.
gt; It would put the amounts that were exclusive to only the date in all
gt; the corresponding month columns across all of the object codes whether
gt; it was exclusive to that object code or not.
gt;
gt; What I'm trying to do is;
gt; Build a general ledger with multiple tabs that refer to 14 different
gt; cost centers. Each of the cost centers spend from 63 different quot;Object
gt; Codesquot; for Example 56200. I need to pull together into a roll-up page
gt; the summary of all expenses on a monthly basis spent in each object
gt; code, by each of the cost centers (A Net Roll-Up).
gt;
gt; So ultimately I need to construct a formula that will go to all 14
gt; worksheets look for exclusive data that refers to the date and also the
gt; object code (ie. 56200), and return the data back to my designated
gt; roll-up page.
gt;
gt; Can someone assist me?
gt;
gt; Thank you in advance!
gt;
gt;
gt; --
gt; My2Boyz9802
gt; ------------------------------------------------------------------------
gt; My2Boyz9802's Profile:
www.excelforum.com/member.php...oamp;userid=33704
gt; View this thread: www.excelforum.com/showthread...hreadid=534954
gt;

Sorry about not including that in my new thread. I just figured I had
royally confused everyone, and needed to start from scratch.

I tried your formula, it didn't work...I tried to finagle it that
didn't work either, so ultimately I was looking for another angle.

Do you think I need to build a pivot table? If yes, I have no clue on
how to do that. I've been working with Excel for well over 10 years
and this task makes me feel as though I've never looked at this program
a day in my life??--
My2Boyz9802
------------------------------------------------------------------------
My2Boyz9802's Profile: www.excelforum.com/member.php...oamp;userid=33704
View this thread: www.excelforum.com/showthread...hreadid=534954Maybe, but you will need to create a helper column to get the date part that
you are seeking.

Pivot tables - See www.contextures.com/xlPivot01.html
and www.peltierteh.com/Excel/Pivots/pivottables.htm--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;My2Boyz9802quot; gt;
wrote in message
...
gt;
gt; Sorry about not including that in my new thread. I just figured I had
gt; royally confused everyone, and needed to start from scratch.
gt;
gt; I tried your formula, it didn't work...I tried to finagle it that
gt; didn't work either, so ultimately I was looking for another angle.
gt;
gt; Do you think I need to build a pivot table? If yes, I have no clue on
gt; how to do that. I've been working with Excel for well over 10 years
gt; and this task makes me feel as though I've never looked at this program
gt; a day in my life??
gt;
gt;
gt; --
gt; My2Boyz9802
gt; ------------------------------------------------------------------------
gt; My2Boyz9802's Profile:
www.excelforum.com/member.php...oamp;userid=33704
gt; View this thread: www.excelforum.com/showthread...hreadid=534954
gt;

Your help is profoundly appreciated!

Candace--
My2Boyz9802
------------------------------------------------------------------------
My2Boyz9802's Profile: www.excelforum.com/member.php...oamp;userid=33704
View this thread: www.excelforum.com/showthread...hreadid=534954