sumif with multiple conditions
 

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.

sumif with multiple conditions
 

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.