Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to sum cross two categories?
I have a journal file and a ledger.
The journal contains expense category, date, value and is randomly sequenced. The ledger is a rectangual array. Rows are expense categories, columns are months. The leger cell for a given expense category / month is the sum of journal entries with the given expense category and month. I have a feeling that Is hould be able to use something like DSUM to do this, but I can't figure it out. I'd appreciate suggestions! I daresay many people have done this, so a reference to a solution would be fine. I don't, of course, have money to solve the problem... or someone else would be doing it. Thanks -- Ian Rowlands |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A budget where receipts are typed in under categories and added f. | Excel Discussion (Misc queries) | |||
cross referancing | Excel Discussion (Misc queries) | |||
How I can add categories in a pivot table? | Excel Worksheet Functions | |||
How do I find a cross reference value | Excel Discussion (Misc queries) | |||
Excel-value in a range of cells for two cross references | Excel Worksheet Functions |