brianparrish
New Member
- Joined
- Oct 18, 2018
- Messages
- 4
Hello,
I am trying to do a spreadsheet where if one column range (A10:A100) have a certain word (such as Acme, Inc), then calculate the total of column range B10:B100 and put that total in cell A2. I've got dropdown menus of various bills that need to be paid, across multiple vendors, but it would be nice to have a cell that shows the totals owed across the various vendors; ie Acme, Inc (cell A2), ABC, Inc (cell A4), etc.
It would be awesome if I could take the results of the figure in A2 or A4 (for this example) and subtract what I have paid, but not put in Quickbooks yet. Such as, the first paragraph gives me a cell A2 total owed to Acme, Inc, but column range C10:C100) has me paid that invoice, but not yet entered. So if the associated cell in column C has a $ figure, then subtract that amount in cell A2.
I hope I made sense of this. Thank you for your time.
I am trying to do a spreadsheet where if one column range (A10:A100) have a certain word (such as Acme, Inc), then calculate the total of column range B10:B100 and put that total in cell A2. I've got dropdown menus of various bills that need to be paid, across multiple vendors, but it would be nice to have a cell that shows the totals owed across the various vendors; ie Acme, Inc (cell A2), ABC, Inc (cell A4), etc.
It would be awesome if I could take the results of the figure in A2 or A4 (for this example) and subtract what I have paid, but not put in Quickbooks yet. Such as, the first paragraph gives me a cell A2 total owed to Acme, Inc, but column range C10:C100) has me paid that invoice, but not yet entered. So if the associated cell in column C has a $ figure, then subtract that amount in cell A2.
I hope I made sense of this. Thank you for your time.