jmuzzarelli
New Member
- Joined
- Feb 4, 2016
- Messages
- 5
All,
I'm working on a file for work and am trying to use a formula to help ensure all data has been copied over. Thank you in advance for taking the time to read this and for any help you may be able to offer.
Here's a table with what I'm looking for. In column F I put what I'm trying to do. I need a formula to sum up the total of column C for all values greater than 0 and then I want it to return the of only the amounts relating to the company listed in Column. E. This is a small scale example, I will be working with thousands of rows and significantly more companies.
<tbody>
</tbody>I've looked a lot online and couldn't find this/was having trouble converting their examples to mine due to the >0 need.
If you have any questions please feel free to ask and I'll answer. Again, I really appreciate any help you can give.
I'm working on a file for work and am trying to use a formula to help ensure all data has been copied over. Thank you in advance for taking the time to read this and for any help you may be able to offer.
Here's a table with what I'm looking for. In column F I put what I'm trying to do. I need a formula to sum up the total of column C for all values greater than 0 and then I want it to return the of only the amounts relating to the company listed in Column. E. This is a small scale example, I will be working with thousands of rows and significantly more companies.
Transferred To | Transferred From | Amount | Company | Transfers In | Transfers Out | ||
NY | IL | 35,000 | NY | =sum of all NY in Col. A where amt. in Col. C is >$0 | |||
NY | KC | -40,000 | IL | ||||
NY | IL | 10,000 | KC | ||||
IL | KC | 5,000 | SG | ||||
NY | IL | -7,500 | |||||
SG | IL | 1,200 | |||||
<tbody>
</tbody>
If you have any questions please feel free to ask and I'll answer. Again, I really appreciate any help you can give.