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.

Here's a small sample file that demonstrates this.

xSumproduct.xls 14kb

http://cjoint.com/?hiwGgpaUrg

--
Biff
Microsoft Excel MVP


"myl" wrote in message
...
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.