littlepete
Well-known Member
- Joined
- Mar 26, 2015
- Messages
- 503
- Office Version
- 365
- Platform
- Windows
hello
I have a long list of amounts of money coming in, and going out for a list of companies.
the companies names are in column E. the amounts of money in column G.
I would like a FORMULA to filter on the name of a company and then see for that company the total amount of money gone out, in a cell,
AND the total amount of money coming in, in a cell next to it, for that same company ...
example:
company A : -5 -15 25 -10 15
company B : 7 -5 12 14 -11
company A : sum of -5 -15 -10 = -30. sum of 15 25 15 = 55.
company B : sum of -5 -11 = -16. sum of 7 12 14 = 33.
I have tried to combine subtotal with other possibilities... no combination succeeded... who knows how ?
thank you !!!
I have a long list of amounts of money coming in, and going out for a list of companies.
the companies names are in column E. the amounts of money in column G.
I would like a FORMULA to filter on the name of a company and then see for that company the total amount of money gone out, in a cell,
AND the total amount of money coming in, in a cell next to it, for that same company ...
example:
company A : -5 -15 25 -10 15
company B : 7 -5 12 14 -11
company A : sum of -5 -15 -10 = -30. sum of 15 25 15 = 55.
company B : sum of -5 -11 = -16. sum of 7 12 14 = 33.
I have tried to combine subtotal with other possibilities... no combination succeeded... who knows how ?
thank you !!!