sumif with multiple conditions

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top