Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sums with several conditions
I've tried several things but I must be missing something.
I've been given a pile of data and have worked things out to something like this example: Firm status <1 1 2 3 3 A a 1 0 0 2 2 b 6 0 0 0 4 c 0 2 3 3 0 B a 1 1 2 0 3 b 1 2 3 1 c 3 3 1 d A a 1 1 0 3 b 1 2 3 c A a b c and so on C a 1000 rows b c d e .. 3 firms .. 3 to 6 statuses .. 7 rows with data/values (the data is imported & calculated) I need totals per firm, per status, per value, so that would be firm status <1 1 2 3 3 A a 2 1 0 5 ... b 7 2 3 ... ... c ... ... ... B a b c d C a b c d e f I've tried several things/formulas but am probably overlooking a simple thing because the totals don't add up right. I've worked with 2007 for a while now, but this one requires 2003 (different functionality) on WinXP sp2. I've changed most of the formulas that were already there successfully, this one won't fly just yet. Thanks in advance for your input. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sums with several conditions
ok, didn't think of the formatting .... so here goes:
FIRM -- STAT -- VAL1 -- VAL2 -- VAL3 --- VAL4 --- VAL5 -- VAL6 -- VAL7 - A ------ a -------1 ------- 0 ------- 2 ------- 5 ------- 0 ------- 2 ------- 5 ---------- b -------3 ------- 0 ------- 1 ------- 2 ------- 3 ------- 1 ------- 2 ---------- c -------0 ------- 2 ------- 8 ------- 16 ----- 0------- 4 ------- 0 - B ------ a -------1 ------- 0 ------- 2 ------- 5 ------- 0 ------- 2 ------- 5 ---------- b -------3 ------- 0 ------- 1 ------- 2 ------- 3 ------- 1 ------- 2 ---------- c -------0 ------- 2 ------- 8 ------- 16 ----- 0------- 4 ------- 0 ---------- d -------3 ------- 0 ------- 1 ------- 2 ------- 3 ------- 1 ------- 2 - A ------ a -------1 ------- 0 ------- 2 ------- 5 ------- 0 ------- 2 ------- 5 ---------- b -------3 ------- 0 ------- 1 ------- 2 ------- 3 ------- 1 ------- 2 ---------- c -------0 ------- 2 ------- 8 ------- 16 ----- 0------- 4 ------- 0 - A ------ a -------1 ------- 0 ------- 2 ------- 5 ------- 0 ------- 2 ------- 5 ---------- b -------3 ------- 0 ------- 1 ------- 2 ------- 3 ------- 1 ------- 2 ---------- c -------0 ------- 2 ------- 8 ------- 16 ----- 0------- 4 ------- 0 - C ------ a -------1 ------- 0 ------- 2 ------- 5 ------- 0 ------- 2 ------- 5 ---------- b -------3 ------- 0 ------- 1 ------- 2 ------- 3 ------- 1 ------- 2 ---------- c -------0 ------- 2 ------- 8 ------- 16 ----- 0------- 4 ------- 0 ---------- d -------3 ------- 0 ------- 1 ------- 2 ------- 3 ------- 1 ------- 2 ---------- e -------0 ------- 2 ------- 8 ------- 8 ------ 0------- 7 ------- 0 ---------- f --------4 ------- 0 ------- 3 ------- 6 ------- 3 ------- 3 ------- 2 hope this is better ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
Sums | Excel Discussion (Misc queries) | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |