M
myl
I have a pivot table with months going across columns and accounts going down
the rows, example:
Account 1 2 3 Total
50000 25 20 15 60
51000 10 15 10 35
52000 20 20 20 60
60000 3 6 9 18
61000 8 10 5 23
62000 4 2 25 31
Total 70 73 84 227
On another sheet, I need to sum all the accounts that start with 5 by month
(across columns). Index-match only gets me one value, how can I sum all the
accounts by the first digit of the account dynamically accross the months?
Have tried number sumif and match combinations, can't seem to work.
the rows, example:
Account 1 2 3 Total
50000 25 20 15 60
51000 10 15 10 35
52000 20 20 20 60
60000 3 6 9 18
61000 8 10 5 23
62000 4 2 25 31
Total 70 73 84 227
On another sheet, I need to sum all the accounts that start with 5 by month
(across columns). Index-match only gets me one value, how can I sum all the
accounts by the first digit of the account dynamically accross the months?
Have tried number sumif and match combinations, can't seem to work.