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

Kemahiran: Excel, Pemprosesan Data, Pemasukan Data, Visual Basic

Lihat lagi: call web service excel formula, excel formula sheet, excel project help needed, microsoft excel formula sheet, getafreelancer message sql query help needed, check excel formula aspnet, python projects help needed, excel formula convert utm latitude, excel macro visual basic help needed urgent, engineering help needed for dolar installation windsor region, excel formula help need onetomany vlookup type of formula, excel formula help, excel formula help: need one-to-many vlookup type of formula, get instant flat rate bids from freelancers for your large or small support needed from a certified quickbooks specialist, image editing - project is for safety90 no bids from others please, image editing project is for safety90 no bids from others please, need help with excel formula, excel help needed, excel help needed in accra ghana, overseas excel spreadsheet help needed

Tentang Majikan:
( 180 ulasan ) Bellingham, United States

ID Projek: #20422859

Dianugerahkan kepada:


I have experience with data entry and spreadsheet. It will be done quickly with utmost care to details.

$20 USD dalam 2 hari
(1 Ulasan)

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

$10 USD dalam 7 hari
(1 Ulasan)

13 pekerja bebas membida secara purata $18 untuk pekerjaan ini


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.

$20 USD dalam sehari
(37 Ulasan)

i am ready to work and very good in excel

$20 USD dalam 7 hari
(0 Ulasan)

In response to your post, I’d like to be considered for your data entry position. I’m a strategic data analysr with a strong background in developing online content. I can turn a phrase in a way that represents your br Lagi

$25 USD dalam sehari
(0 Ulasan)

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.

$10 USD dalam sehari
(0 Ulasan)

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.

$35 USD dalam 3 hari
(0 Ulasan)

Hi,I am Ramzan and it will be my pleasure to assist you with this project. I have read your project [login to view URL] can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly commun Lagi

$10 USD dalam sehari
(2 Ulasan)

I have previous experience in this feild and also I am hardworking and dedicated to my work and will complete the given work before deadline.

$15 USD dalam 4 hari
(0 Ulasan)

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.

$10 USD dalam sehari
(1 Ulasan)

I am mis lead in multi national company so i can complete you work faster and in efficient way. Thanks

$25 USD dalam sehari
(0 Ulasan)

I have several years of experience performing similar tasks and am confident I can deliver the product as requested. Thank you for your consideration.

$15 USD dalam 7 hari
(0 Ulasan)

Hello, i wrote my thesis with Excel and Excel VBA. In this case VBA is not required. I already know the formula. I can completely optimize your Excel. I'm german and travel the world with my motorbike. We can help ea Lagi

$15 USD dalam 2 hari
(0 Ulasan)