I need help with an excel spreadsheet creation with formulas
column 1 Transaction Date
column 2 Vendor name
column 2 Project name
column 3 Descrription
column 4 Expense
column 5 Capital
column 6 Balance
now to the difficult part:
column 7 has list of all vendors, example Joe, Bob, Peter
column 8 holds their totals
any time there is a transaction in column 4 , for whom the vendor is 'Joe', that amount must be added to the total on column 8 against Joe's total. So I made transaction for $500 on 3-9-19 and $200 on 3/11/19, then Joe's total on column 8 must show $700
column 9 lists all projects by name, example Dodge, Chevy, Benz
column 10 lists total amounts in each of these specific projects
any time there is a transaction in column 4, for which the project name is 'Dodge' that amount is added to the total on colum 10 against Dodge's total. So if the transaction I made for $500 with Joe on 3-9-19 was for the Dodge project and the transaction i made on 3-21 with bob for the Dodge project was for $100, then the dodge total will add up to $600
Được trao cho:
Hey, I am a professional excel user for past 10 years. i understood your task. Can help you out in 30 minutes. have just started on freelancer platform and exited to engage with you as my first assignment. Thanks
13 freelancer chào giá trung bình$18 cho công việc này
Hi, I have understand the project requirement & interested to make formula for this project. Please send a message so we can discuss more & start the project. Thanks.
Dear Employer: I can do your project in fixed time and with perfection. If you'll hire me then this will be my first project on freelancer and I'll give my all effort for my good startup.
Good morning! I have a lot of experience working with Excel, and I would be happy to do this job for $30 USD. I look forward to hearing from you! N.H.
Hi, It looks like the task wont take too much time, so I do bid minimum amount and will execute in couple of hrs.. Even more i can provide with some extensions to make the data input easier.
I have several years of experience performing similar tasks and am confident I can deliver the product as requested. Thank you for your consideration.