Completed

Making excel table for sub totals

Make an excel sheet that automatically sum expenses according to Account Name and Class Name. Input data- table with the following columms :Name,date, description,amount, account name, class name. This table will include expenses reports (typically 10 to 30 expenses). The result should be a table that automatically sums the total amounts for each combination of Account name&Class name. Preferably shows only the combinations that actually have an amount that is different than zero. Total number of Account names is about 10, total number of Classes is about 40. The result table should have the following columns: account names, class names, sum of amount.

Skills: Excel

See more: solidworks design table excel, excel making formula, pivot table excel cnet, update access table excel, word table excel conversion, php export table excel, access update table excel file, vsto pivot table excel, cross table excel

About the Employer:
( 4 reviews ) Singapore, Singapore

Project ID: #8676733

Awarded to:

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among More

$30 USD in 1 day
(164 Reviews)
6.8

56 freelancers are bidding on average $22 for this job

zExcel

A proposal has not yet been provided

$50 USD in 1 day
(204 Reviews)
7.2
raghav1101

Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Please contact with further details if interested. Regards R More

$24 USD in 1 day
(57 Reviews)
5.8
Ibrahim185

Hi, After reviewing the project description I know that I'm an excellent fit for this [login to view URL] send me more details. I have enough flexibility with my current schedule to do this [login to view URL]'s discuss and start rig More

$30 USD in 2 days
(79 Reviews)
5.3
gokulanand

Hello I can get you the task done in the next 1 to 2 hours. Let me know if you are interested. Thanks

$20 USD in 0 days
(63 Reviews)
5.3
watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

$20 USD in 0 days
(82 Reviews)
5.2
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv More

$30 USD in 1 day
(33 Reviews)
4.9
AlexandrK1

Предложение еще не подано

$30 USD in 1 day
(13 Reviews)
4.5
zebracaro

I can do it for you quickly and exactly .

$35 USD in 2 days
(39 Reviews)
4.5
someka

You dont need to award me now. Just drop me a message so that we can discuss further about pricing and job details.

$19 USD in 0 days
(34 Reviews)
4.6
rajafaizan

I am very interested in your project. I have 5+ years exp. in MS Office, Designing, Quick-books, Office Management, PDF, Google spreadsheet, Vba and typing. I will give you my best possible work. I would like to thank More

$23 USD in 1 day
(21 Reviews)
4.2
TonmoyRoy111

A proposal has not yet been provided

$20 USD in 0 days
(28 Reviews)
3.9
prabakarm23

Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv More

$35 USD in 2 days
(24 Reviews)
4.0
abumusalilla

Hi, I am available right now. I done your work as per your requirement also within time and budget. Contact me. Thanks and Regards Asif

$25 USD in 0 days
(17 Reviews)
3.5
fatimatuzzohura

Hi, I am very much interested and have experience to do Excel, PowerPoint, scraping work. I worked with many different American Law years, Entrepreneurs and Email Marketing Company of some extensive and difficult emai More

$30 USD in 1 day
(11 Reviews)
3.6
latishbch

Available now to contact (Chat/PM) and start the project. Also please do look at my portfolio for my past work and 100% satisfied reviews from earlier projects ***SPECIAL NOTE*** - Quickest delivery time than an More

$11 USD in 1 day
(11 Reviews)
3.2
hachohenr19

Hello I WOULD LIKE TO HELP YOU IN YOUR PROJECT I HAVE EXPERIENCE AND SKILLS IN ADVANCED EXCEL. I GUARANTEE PROFESSIONAL WORK. I HOPE YOUR CONTACT. THANK YOU...

$15 USD in 1 day
(2 Reviews)
2.1
onlineworkmasum

Hi, Please contact me. Do u need the excel table in 2007 format? Waiting for ur response Thanks Masum

$34 USD in 1 day
(1 Review)
1.8
UsmanNasar87

I have very good knowledge in MS Excel such as formulas, pivot table, charting etc. You may contact with me regarding your project.

$25 USD in 1 day
(1 Review)
1.5
majdziadi

Good morning; I'm very happy to know about your offer since i have been very familiar with this type of work. I promise an excellent feedback with good work quality in time! Hope to hear soon from you. Best reg More

$12 USD in 1 day
(1 Review)
0.6
Shalinivats0409

I can work in excel with great speed and highest degree of accuracy. I can also assure about the desired level of efficiency and timely completion. I can also work with pie-charts, drawing and graphs in excel.

$25 USD in 1 day
(1 Review)
0.4