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
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
15 freelancers are bidding on average $18 for this job
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.
Hi,Sir! I 'm Alex. Nice to meet you! I read your description. I am a excellent Excel expert. I 'm able to complete your project perfectly. I hope you contact with me. Thank you!
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.