Is there a way to set up a formula in numbers that will sum up values in table columns that have a certain index number in another column.
for example:
A B C
1 5 10
3 4 12
5 5 15
3 2 12
I would like the sum of the values in column B & C where there is a 3 in column A.
In this example the formula would return 30
iMac, Mac OS X (10.6.8), 500GB HD ; 2GB ram; 2.33mhrz dual intel chip;SuperDrive-PIONEER
Here is a possible solution:
Use column D to simplify the problem:
row 1 is a header. To make is a header use the contextual menu for the first row:
D1="TOTAL = "& SUM(D)
D2=IF(A2=3, SUM(B2:C2), 0)
select D2 and fill down
What I actually have is several hundred lines and 10 accounts (index numbers) for which I want to sum the debits (B)and credits(c) for each account(A, index) . I was tryng to do this on another summary sheet, using array calculations in the "IF" without having to have an entry for each index line and I got stymied. Maybe it just cant be done.
Here's another way that uses another table:
B2=SUMIF(Table 9 :: A, "="&A2, Table 9 :: B)+SUMIF(Table 9 :: A, "="&A2, Table 9 :: C)
select B2 and fill down
the top table with your accounts in the the first column is titled "Table 9"
Thaks so much, that is exactly what I want to do. I dont know how I missed out on the SUMIF function!
How to sum values in a table row that match a given index
