Solved

How to add positive numbers in a column?

Posted on 2013-06-10
2
187 Views
Last Modified: 2013-06-10
I have numbers in column C, rows 2 to 72.  How do I specify formula to add all numbers and place the sum in C73 or C74.


Thank you!
0
Comment
Question by:naseeam
2 Comments
 
LVL 18

Accepted Solution

by:
Matthew Kelly earned 250 total points
ID: 39236519
To add all numbers in column C, rows 2 to 72 put:

=SUM(C2:C72)

Open in new window



In either C73 or C74.
0
 
LVL 1

Author Closing Comment

by:naseeam
ID: 39236525
Very fast and concise!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question