Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding and summing data in somewhat complex matrix.
Hi,
I am having trouble with the following, and wonder if someone can help me out. We have a periodical dump of ledgerdata, which is divided in Budget and Realisation info. The format (i.e. the number of lines with Budget- or Realisation data) varies per period. Furthermore the data is specified (columnwise) over approx. 30 cust-units. The data has to be reported per cost-unit on separate sheets, and is ultimately aggregated to company-level. The dataset looks like this: Type Ledger# unit1 unit2 unit3 unitn Budget 1 10 20 30 50 Budget 1 5 15 25 33 Budget 4 1 0 10 15 Real. 1 5 10 20 25 Real. 4 7 15 20 38 Real. 4 2 5 5 5 I am looking for a formula that finds whether it is a Budget or Realisation, and then sums the values per ledger# per cost-unit. Presently I find the data by defining the exact range (e.g. Budget data is in A2:AZ136), and then use SUMIF to sum the data per ledger#. With 30 cost-units this means a lot of find&replace. Any suggestions? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complex criteria summing | Excel Discussion (Misc queries) | |||
Where to find complex matrix math add-ins for Excel 2003? | Excel Worksheet Functions | |||
How to compute the inverse of a matrix with some complex elements | Excel Worksheet Functions | |||
How to do matrix operation with complex number elements in Excel | Excel Worksheet Functions | |||
Matrix operations with complex numbers | Excel Discussion (Misc queries) |