Excel project - tally & sum amounts by calendar month

Simple excel project.

We have 2 lists in separate tabs in excel. Each list has a date in the first column and a monetary amount in the second column. We would a table completed (see respective tabs) that adds up the sum total of the entries per calendar month.

List A has 1608 entries and List B has 890 entries.

The first entry for list A in the table should therefore be £13,457.63 (the sum of the entries from list A that are from January 2015.

Evner: Excel, Databehandling

Se mere: simple excel project grade, excel project manage template web design, excel project task list, visual studio excel project, excel project help needed, creating simple excel project, excel project simple, excel project timeline simple, simple excel project analysis, simple excel project input data, simple excel project list, excel project plan month month, simple excel project database, tally excel project, create simple vba excel project, how to create a project timeline template today in 10 simple steps using excel 2010, excel year to date sum based on month, excel+year to date sum based on month

Om arbejdsgiveren:
( 2 bedømmelser ) Staverton, United Kingdom

Projekt ID: #23383269

Tildelt til:


Hi There! I've already completed this task. The trick in doing this is using SUMIF and having some text formatting. See screenshot result of the table A here: [login to view URL] Flere

£15 GBP på 1 dag
(5 bedømmelser)

24 freelancere byder i gennemsnit £14 på dette job


its simple task,u just need sum of each month in table a and table b sheet i can do right now 2nd entry in table a would be for 2/1/2015=8398.90

£10 GBP på 1 dag
(527 bedømmelser)

Hi, I read your project carefully and completely understand it "I am certified in Microsoft Office, Microsoft Excel, Word and Access. I have good command over data management in Excel Dashboard, Spreadsheet as well as Flere

£17 GBP på 1 dag
(224 bedømmelser)

Hello, this is very simple, if you are interested in working with me, please message me. I believe i can create this sum formulas for you in less than 15 minutes. I've done similar thing many times before. Thanks, Mil Flere

£14 GBP på 1 dag
(511 bedømmelser)

Hello there. I checked your project description (complete excel tables in 2 sheets).I can do your project in less than 24 hours according to your description with full delivery and without error. I would also complete Flere

£30 GBP in 2 dage
(119 bedømmelser)

Hello, I am willing to do your project and ready to start work. Please response. Thanks Ramjan

£13 GBP på 1 dag
(94 bedømmelser)

Hii I would like to work for you on this project in low budget and in good time. I have enough experience of this field. We can start work as soon as possible. Thank You

£20 GBP på 1 dag
(19 bedømmelser)

Hi Sir I am interested in your project Sir after reading the project description I am offering my services to complete the project. Sir I think that I am the right person for which you are looking for your project. Sir Flere

£10 GBP på 1 dag
(41 bedømmelser)

Hi there. I have read and understood every requirement of your project. I am proficient in data processing, excel, VBA with 5 years of experience. Hence, I am interested in working on your project. I am sure to deliver Flere

£15 GBP på 1 dag
(14 bedømmelser)

I Would like to help you Sir with that task. If i am understanding correct, then the second entry/value should be (8,398.9) am i right !? Please find my bid. Thank you.

£12 GBP på 1 dag
(13 bedømmelser)

Hello Sir Please check this link for sample work [login to view URL] Regards Manoj

£10 GBP in 2 dage
(7 bedømmelser)

Hello, I'm ready to help you to tally and sum the ammounts as I have experience in Accounting and Excel.. Thank you.

£10 GBP på 1 dag
(2 bedømmelser)

HI There I have seen your Project details and I think I am the perfect one for this project. I’m an expert in MS Excel and can deliver this work before deadline after selection. In terms of my work quality, I have co Flere

£10 GBP på 1 dag
(1 bedømmelse)

Hi sir/madam I can do to this work please tell how to get money for the after work. I will do this work correctly.

£15 GBP in 7 dage
(0 bedømmelser)

I have already done your work as per your requirement. Kindly check it. I am sure you will find it accurate and up to the mark. Thanks a lot in advance if you select my bid.

£10 GBP på 1 dag
(0 bedømmelser)

This is a simple Excel project and can be delivered within an hour. You can contact as I already did it.

£15 GBP på 1 dag
(0 bedømmelser)

Hello? I am interested about your project and it's my top skill. I already decided to do this so you must check me. Hurry up! There is only one chance. If you use chance well, you will have perfect project and new frie Flere

£15 GBP in 7 dage
(0 bedømmelser)
£18 GBP på 1 dag
(0 bedømmelser)

saya siap bekerja sesuai dengan yang anda harapkan, jika saya diterima, saya akan bekerja dengan sungguh-sungguh.

£13 GBP på 1 dag
(0 bedømmelser)

Dear Friend I have very experince with datasheet and I'm able to make this work. Contact me, please. Thanks I'm Frelancer in WebDev, please give me an opportunity.

£10 GBP in 7 dage
(0 bedømmelser)

I am a fast learner, hard worker, result-oriented and trustworthy - a perfect addition to any team of professionals! I perform extremely well under pressure and I'm comfortable working with tight deadlines. Always read Flere

£10 GBP på 1 dag
(0 bedømmelser)