Hello,
I have a data range with 3 columns - A -employee number, B -charging number, and C -charge amount.
"A" shows multiple times and must be associated with value from "B". I am looking for totals of "C" for any combination of "A" and "B".
Ex.
A B C
1 101 6
1 201 7
1 101 4
2 301 6
2 101 1
2 201 4
3 201 5
3 401 7 etc.
I am looking for totals (from column C) for A and totals for A with defined B. e. g.:
1 for all 101
1 for all 201
1 total
2 for 201 etc..
Thank you for your help.
Siskin
Bookmarks