Excel Sum Up Macro 
Hi coders I have uploaded an excel file with some data in it, download it before bidding. I am trying...trying to do some summing up based on the data in column L. What I am looking to do is there are a bunch of...in column L and I want a macro that will give me sum calculations for columns M through AJ and place the 
27 
Translation, SQL, MySQL, Anything Goes, Database Administration 
Nov 28, 2009 
Nov 28, 2009Ended 
$30 
Sum up data 
I have an excel table as shown in the picture. In it you would see column headers and under them 1s.

7 
Data Processing, Data Entry, Excel 
Mar 15, 2015 
Mar 15, 2015Ended 
$17 
excel function to sum count of entries in column 
...an excel spreadsheet with 2 columns of data, a timestamp and a value.
I would like an excel function(s)...summary ie 19:00:01, and the second column being the sum of the count of the timestamps for the previous second 
24 
PHP, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL 
Jul 25, 2008 
Jul 25, 2008Ended 
$18 
Excel Sum Up Project Script or Macro 
...solution to sum up multiple rows in excel. I am uploading an excel file that contains the data I need sumed...that need to be added up.
Right now all the data is sorted alphabetically. Anytime that a cell in...me. I plan to use this script or excel function with different data but same column headers and format 
5 
PHP, Engineering, SQL, Software Architecture, Software Testing, Website Testing, MySQL, Website Management, Database Administration, Web Hosting 
Nov 6, 2009 
Nov 6, 2009Ended 
$35 
Find Target Sum in EXCEL 
...I want a program for excel that will tell me which numbers equal my target sum by placing a qualifier...the range of acceptable variance from the target sum to be entered. ie if no results are found the option...feature that looks similair to the f2 function in excel. It should not take more than a few minutes. 
7 

Mar 25, 2008 
Mar 25, 2008Ended 
$251 
To earn additional sum when staying at home 
I have sound knowledge on Microsoft Excel including data analysis as well as handling accounting softwares 
1 
Excel, Quickbooks & Quicken, Tax, Word, MYOB 
May 3, 2015 
May 3, 2015Ends  4d 3h 
$155 
calculation sum 
I need a excel spreadsheet to be created that can be a simple sum calculator. I want it to be converted 
4 
Website Design, PSD to HTML, HTML 
Mar 10, 2011 
Mar 10, 2011Ended 
$41 
Analyze Spreadsheet and Sum Data 
...single line client bill entries.
I need you to sum the total for each client and then spit out a list...total amount we have billed them.
Spreadsheet data looks like this:
Shai Harary $155.53
Shai 
4 
Data Processing, Excel 
Sep 10, 2014 
Sep 10, 2014Ended 
$21 
Excel formular  Sum up multiple data in multiple cells & record down the order no. 
...product quantity. This formula is bestly based on Excel. It is a $30 project.
In sheet 1,
A column...no.
I need to add a Sheet 2, sum up all the corresponding data in Sheet 1 and sort in below format:

19 
Visual Basic, Excel 
Mar 11, 2008 
Mar 11, 2008Ended 
$30 
simple costing sum $10 
...I want the solution of attached simple sums in excel sheet. I want them solved in 23 hours at the maximum 
7 
Accounting, Finance, Academic Writing 
Aug 4, 2014 
Aug 4, 2014Ended 
$7 
Do some Excel Work 
data entry sum subtraction etc. 
0 
Data Processing, Data Entry, Excel 
Jan 8, 2015 
Jan 8, 2015Ended 
 
Mathematic formula to compute a sum 
We need a a mathematic formula to compute the sum of the first n terms in the following progression (no...xn = xn1*(1+d)  r What is the formula for the sum x1+x2+ ...+xn? Eg: x1 = 1000 d = 0.0096 r = 256.02...x1+x2+x3+x4 = 2513 Please bid stating the sum for the following data set: x1 = 5000 d = 0.0096 r = 109.96 
14 
PHP, Windows Desktop, Linux, Engineering, SQL, Software Architecture, Mac OS, Software Testing, Website Testing, Chrome OS, MySQL, Amazon Web Services, UNIX, Website Management, Database Administration, Web Hosting 
Oct 5, 2007 
Oct 5, 2007Ended 
$9 
Calculate Check Sum in VB 
...code, text data, 2bytes check sum and end code. This program needs to calculate a check sum and compare...block number, 2F > 2F = data, 45 and 30 = check sum, 0D = end code). The check sum used is: 2 bytes hex...number, loworder 8bit data of the complement of 2 for the sum of text data. So if someone knows what 
15 
PHP, Visual Basic, .NET, Engineering, Software Architecture, Software Testing, MySQL 
Nov 9, 2004 
Nov 9, 2004Ended 
$35 
Do some Excel Work 
DATA OF NUMERIC AND I REQUIRE THE WORK FOR SUM & AVERAGE 
14 
Data Processing, Data Entry, Excel 
Apr 8, 2015 
Apr 8, 2015Ended 
$106 
Python programming/pycharts/sum of squares error sum((X  Y)**2). 
...experiment. This system should take a learning model, a data manager, and a file loader. It must use those things...r2 number (scikit score function), and sum of squares error sum((X  Y)**2).
The PyPlot chart should...should contain 2 lines for each set of data, the true values and the predicted values. Both axis should have 
2 
Python, Software Architecture 
Mar 31, 2015 
Mar 31, 2015Ended 
$27 
Excel Data Entry 
Excel data entry 3 columns roughly 150 lines.
Sum of parts must equal wholes (income statements) 
6 
Data Processing, Data Entry, Excel 
Oct 21, 2014 
Oct 21, 2014Ended 
$19 
Excel Data Entry 
Excel data entry 3 columns roughly 150 lines.
Sum of parts must equal wholes (income statements) 
45 
Data Processing, Data Entry, Excel 
Oct 17, 2014 
Oct 17, 2014Ended 
$23 
Excel Data Entry 
Excel data entry 3 columns roughly 150 lines.
Sum of parts must equal wholes (income statements) 
49 
Data Processing, Data Entry, Excel 
Oct 17, 2014 
Oct 17, 2014Ended 
$22 
3Sum problem (easy assignment) 
...implementations of the 3SUM problem. I need to implement a brute force solution for the 3SUM problem and run...version of the 3SUM problem in which you first use an Insertion Sort to sort the input data and use a Binary 
17 
C Programming, Data Processing, C++ Programming, Assembly 
Jan 22, 2015 
Jan 22, 2015Ended 
$27 
3Sum problem (easy assignment) 
...implementations of the 3SUM problem. I need to implement a brute force solution for the 3SUM problem and run...version of the 3SUM problem in which you first use an Insertion Sort to sort the input data and use a Binary 
16 
C Programming, Data Processing, C++ Programming, Assembly 
Jan 29, 2015 
Jan 29, 2015Ended 
$22 
Advanced excel 
Hi Priyal, do you know how to sum same data sets on identical sheets across multiple sheets (I have 40)...names from my list to sum? I was hoping there was a variation on the formula =SUM(First:Last!A2) which...which would work if I wanted to sum all sheets all of the time. Regards Ben 
1 
Excel, 
Aug 3, 2014 
Aug 3, 2014Ended 
$18 
Read numbers from file and calculate sum and average 
...number, the sum and the average. Repeat until the end of the file.
For example, the data are stored...number = 1 Sum = 1
i = 2 number = 2 Sum = 3
Average = 1.50
Group Size = 3
i = 1 number = 1 Sum = 1
i...number = 2 Sum = 3
i = 3 number = 3 Sum = 6
Average = 2.00
Group Size = 4
i = 1 number = 1 Sum = 1
i 
9 
C Programming 
Nov 21, 2013 
Nov 21, 2013Ended 
$22 
Excel macro / data processing script 
...information to an output of just:
Address_id
(sum of all related) RRP
That is, where we currently...per row. Each unique Address_id should also have a sum of the RRP values that are attributed to it.

27 
Data Processing, Data Entry, Excel 
Dec 4, 2013 
Dec 4, 2013Ended 
$105 
Solve the Given Sum Operation from Images 
...want a worker to solves these and write it into excel or csv file according to the filname
hope to 
43 
Data Processing, Data Entry, Copy Typing 
Aug 18, 2013 
Aug 18, 2013Ended 
$81 
Solve very easy accounting sum  100 INR 
...solved a capital budgeting sum. I want proper and explanatory solution on excel spreadsheet. Deadline is 
1 
Accounting, Finance, Academic Writing 
May 25, 2014 
May 25, 2014Ended 
$1 



Data Processing, Data Entry, Excel 
Dec 19, 2011 
Dec 19, 2011Ended 

excel sumif help 
i am adding data in a range that also includes percentages  but don't want to include the percentages...percentages in the sum calculation. How do i do this please? 
9 
Excel 
Mar 1, 2014 
Mar 1, 2014Ended 
$19 
DATA ENTRY 
...WITH DATA AND SIMPLE EXCEL DATA ANALYSIS LIKE SUM, LOGISTICS, GRAPHS CHARTS AND ANY OTHER EXCEL SKILLS 
1 
Data Entry, Research, Excel, Articles, Web Search, 
Sep 12, 2014 
Sep 12, 2014Ended 
$150 
From excel to data base 
...need a simple input  output data , report and stock( from inout data orders) for tracking( "history")... ( like in excel file attached  they have same formulas that need to be the same " sum" and "multiply" 
5 
PHP, Software Architecture, Microsoft Access, MySQL 
Jan 12, 2013 
Jan 12, 2013Ended 
$154 
Data Entry and Formatting in Excel 
...that. I will give you a number of Excel spreadsheets containing PAST data that is formatted correctly. I...will then give you CURRENT data in Excel format. You must enter the CURRENT data in the spreadsheets the...PAST. For each spreadsheet, you will also need to sum certain numbers and perform certain functions as 
47 
Data Entry 
Nov 3, 2010 
Nov 3, 2010Ended 
$8 
excel sheet data entry 
...I need to key in from old bank statements into Excel all my Bank Transactions
(Date / PAYEE / Ref...drop box (or similar)
In return I would like an Excel Spreadsheet (1 tab per Bank Account) with 6 yearsâ...and some reasonableness checks along the way (i.e. sum of all transactions in a month is same as the movement 
27 
Data Processing, Data Entry, Excel, Virtual Assistant, Web Search 
Jul 4, 2012 
Jul 4, 2012Ended 
$328 
Running sum per year, account and id 
...table. The query must calculate the balance (running sum) per year, account and id.
I have allread the query...can provide the existing query and the table with data. Please keep in mind that the code must be storable 
20 
MySQL 
Feb 4, 2014 
Feb 4, 2014Ended 
$20 
VBA excel pivot 
I have data in a pivot table in excel. I need that on the click of a botton or checkbox the value in...in my pivot change from the sum of value of in one of the pivot fields to another. 
4 
Visual Basic, Excel 
Dec 15, 2014 
Dec 15, 2014Ended 
$102 
Do some Excel Work 
...Most Popular service seems to be entering data into Excel or analyze them. One project I did was entering...entering names,addresses,calculating the average, sum, difference, graphs, tables, sorting from my last 
24 
Data Processing, Data Entry, Excel, Powerpoint, Word 
Jun 18, 2014 
Jun 18, 2014Ended 
$19 
Do some Excel Work 
...Most Popular service seems to be entering data into Excel or analyze them. One project I did was entering...entering names,addresses,calculating the average, sum, difference, graphs, tables, sorting from my last 
32 
Data Processing, Data Entry, Excel, Powerpoint, Word 
Jun 18, 2014 
Jun 18, 2014Ended 
$20 
DATA ENTRY  open to bidding 
...WITH DATA AND SIMPLE EXCEL DATA ANALYSIS LIKE SUM, LOGISTICS, GRAPHS CHARTS AND ANY OTHER EXCEL SKILLS 
11 
Data Entry, Research, Excel, Articles, Web Search 
Sep 14, 2014 
Sep 14, 2014Ended 
$135 
Excel programming 
I have data in a large spreadsheet (attached as Sample Data). Each row is one report. Data in column...to generate a report from the Sample Data that sets out the sum of the characters by day within 4 different...work type.
I need to be able to take the Sample Data sheet of any number of rows and be able to use this 
57 
Data Processing, Data Entry, Excel 
Dec 3, 2013 
Dec 3, 2013Ended 
$883 
Do some Excel Work 
Need to sum and transpose the data from about 1600 rows. This is a ledger that was pulled from Quickbooks...25 as an example. There are about 130 groups of data (the example set of rows 15 to 25 is one group)...the data in columns B through J to populate the summary in columns L through R. So with the data from 
6 
Data Processing, Data Entry, Excel 
Jul 21, 2014 
Jul 21, 2014Ended 
$111 
Excel expert 
My company currently uses Excel to generate individual health reports. We are seeking a person with...with extensive experience with Excel to modify this workbook to update its contents, modify its appearance...assessed. Each time the patient is assessed, the new data is entered and this is then compared graphically 
37 
Data Processing, Data Entry, Excel 
Mar 28, 2013 
Mar 28, 2013Ended 
$125 
Excel 2010 VBA Help 
...have in Excel. On a very regular basis, I download ‘stream data’ and have to manually sum the data in a...take the sum and place it in a ‘results’ sheet. The sum calculation will vary by the ‘data as of date...date month_year’. Meaning that if the ‘data as of date month_year’ is say &lsquo... 
4 
Visual Basic, Excel 
Jan 18, 2012 
Jan 18, 2012Ended 
$42 
VB Coding for excel report 
...amount.
We need to ability to sum these blocks and pull some of the data into a line item per contractor...intuitive for us to add new contractors, so that it will sum them and add them to the line item page.
This 
26 
Visual Basic, Excel 
Aug 23, 2013 
Aug 23, 2013Ended 
$93 
Need an EXCEL EXPERT to create a macro 
...F)
For Unique companies, sum Total Wages (Column P) into Column Q
Move Sum back to Column P
Delete...Duplicate Entries
Separate States with 4 Blank Rows
Sum the total (Column P) for Each State
Delete Column...result should look.
Need a macro created. No data entry people please. 
15 
Visual Basic, Excel 
Mar 8, 2010 
Mar 8, 2010Ended 
$50 
MS Access running sum field and others for personal bank organizer 
...built, but Im having problems creating a running sum in a continuous form to know how much do I have today...balance from past bills.
I used to manage this in Ms Excel, and I include the file so that you can get the...idea.
Please bear in ming that the running sum must belong to the corresponding owner of the bank 
15 
PHP, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL, Anything Goes 
Apr 7, 2006 
Apr 7, 2006Ended 
$73 
Do some Excel Work 
Need to sum and transpose the data from about 1600 rows. This is a ledger that was pulled from Quickbooks...25 as an example. There are about 130 groups of data (the example set of rows 15 to 25 is one group)...the data in columns B through J to populate the summary in columns L through R. So with the data from 
28 
Data Processing, Data Entry, Excel 
Jul 21, 2014 
Jul 21, 2014Ended 
$110 
Excel Formulas in an Excel workbook 
An easy Excel project, for an experinced professional. I need a couple of formuals built in the appropiate...cells to sum and gather information. Most of the work is arrays and should take an experince Excel programmer...exceuted upon the user sleecting a month from the data sort filter.
I would ask that this be done 
1 
PHP, Windows Desktop, Linux, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX 
Aug 21, 2006 
Aug 21, 2006Ended 
$10 
sum of intergers 
Sum of the intergers: Write a program that adds up the numbers 0  39 using a loop. Check that is has...answer by using the formula for the sum of the numbers 0  n: sum= n x (n+1)/2
## Deliverables
Complete 
4 
PHP, Java, Windows Desktop, Engineering, Software Architecture, Software Testing, Microsoft, MySQL 
May 9, 2002 
May 9, 2002Ended 
$4 
Do some Excel Work 
I know Excel very well. I have prepared Project comparing two dat.ompany ITC & BBC 1.
I have sorted...sorted out data, make charts to compare their figure more over i have used lots of function like sum, average 
4 
Data Processing, Data Entry, Excel 
Sep 22, 2014 
Sep 22, 2014Ended 
$409 
Code addition for Excel VBA Sub() 
...code that has data streams with multiple assets. So, for each asset in the stream, the sum for each type...differentiate when to sum from where one asset ends and another begin;
2) The results data must be able to...target cell, if there is data in that cell step down one cells and place the next sum there and so on). 
4 
Visual Basic, Excel 
Jan 23, 2012 
Jan 23, 2012Ended 
$30 
559946 Microsoft Excel Exercise 
Complete the following tasks by using the Microsoft® Excel® document provided on the student website:
•...using the existing data and provide labels and a legend.
• Insert a border around data.
• Freeze the...the first column of the data set.
• Sort the daily spending amounts in ascending order.
• Using the 
1 
Excel, Microsoft, Anything Goes 
Apr 3, 2012 
Apr 3, 2012Ended 
$20 
Excel Spreadsheet Calculation 
I have an excel spreadsheet with a few macros in it that do some basic data manipulation. I need to modify...columns, one of which specifies a date. I need to sum up the numbers on the other two columns based on...circled in red is what needs to be done).
The excel sheet is also provided. Subroutine GetLocationData() 
41 
Visual Basic, Excel 
Jan 23, 2014 
Jan 23, 2014Ended 
$21 