DISCLAIMER: I am a complete noob. 24 hours into Excel and I have a decent inventory, accounts payable sheet going on. I want to find out what my outstanding balance to my Vendor is.
I have a column for Date Paid To Vendor (Q), the data that goes in here is a date.
I have a column for Individual Payment to Vendor (N)
I have a column for Total Payout to Vendor (AC), which is the sum of all the money in column N
What I want to do is this:
Every time any cell from Q2-Q100 has a date in it, I want the payment in the corresponding column (N) to be subtracted from the Total Payout to Vendor (cell AC):
Example: Payment to vendor happened on 2/9/12 (column Q) for 10.00 (column N). If the total balance was $100 (cell AC), when I enter the date into (Column Q) I want it to subtract the number in Column N from AC.
I want this to happen anytime I enter a date into Column Q. So it should subtract any value in the corresponding N column and row.
I tried to do this with the IF function, but it got me nowhere.
I basically want to say IF Q is equal to a date, then minus the corresponding row in column N from the amount in column AC3.
Any help would be greatly appreciated.
Bookmarks