Hi there!
I'm looking to sum up a unique list. I've attached how i want the data to look.
I want all the Student A, Student B, etc summed up in a new 'table'. I know i can use a pivot table for this, but if possible i would like to use a formula.
I would also like it dymanic, so that if a Student D, etc was added to COL A then it would automatically add it to the summed table (COl D).
Make any sense?
Thanks.
I'm looking to sum up a unique list. I've attached how i want the data to look.
| AkonaTimekeeping2.xls | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | Client | Billable | Client | TotalBillable | |||
| 2 | StudentA | $10.00 | StudentA | $20.00 | |||
| 3 | StudentB | $30.00 | StudentB | $90.00 | |||
| 4 | StudentA | $10.00 | StudentC | $20.00 | |||
| 5 | StudentB | $50.00 | |||||
| 6 | StudentC | $20.00 | |||||
| 7 | StudentB | $10.00 | |||||
Sheet1 | |||||||
I want all the Student A, Student B, etc summed up in a new 'table'. I know i can use a pivot table for this, but if possible i would like to use a formula.
I would also like it dymanic, so that if a Student D, etc was added to COL A then it would automatically add it to the summed table (COl D).
Make any sense?
Thanks.
