Comments on: 5 ways to sum a column in Excel

This tutorial shows how to sum a column in Excel 2010-2013. Try out 5 different ways to total columns: find the sum of the selected cells on the Status bar, use AutoSum in Excel to sum all or only filtered cells, employ the SUM function or convert your range to Table for easy calculations. Continue reading →

Comments page 3. Total comments: 98

  1. this is stupid. people already know how to do this junk. how do you sum up the entire column that could be 2 rows today and 34904it0934i860938663 rows tomorrow. why bother putting up the same easy garbage that everyone else on here has. be original and do something useful.

  2. I am trying to add a total of names in a spread sheet. How do I go about doing that?

  3. I am doing a item retail price list I need to convert each individual line total from wholesale to retail for example $34.00 needs to actually read $136.00 so its the 1st price x 4 I'm new to using excel and don't really have time for researching the tutorials help pleas

    1. Hi Lulubelle,
      if the totals are in J column (starting from J1) and you need to multiply them by 4 and return the result in column H, then put the following formula in H1:
      =J1*4
      To apply the formula to the whole column, position the cursor to the lower right corner of the cell with the formula, wait until it turns into the plus sign, and then double-click the plus.

      If you want to calculate everything in the same column, you will need to read this part of the article, since there are some important steps to follow.

  4. Hello all,

    I need a formula where I can add column A and column B and then add 10% of the total.

    For example: 10+10 and 10% of the total (10+10) in column C.

    1. =SUM(A1:B2)+0.1*(SUM(FA1:B2))

  5. how to add the 11-60 in excel in single field

  6. I want to get a total of the last number entered in column L and the last number entered in column J automatically. That sum needs to be entered in column L as soon as I enter a number in column j.

    Example: column L last number entered on line 380 + last number entered in column J line 381. sum to be automatic as soon as column J is entered. Want this to continue all the way until I finish all columns at end of work sheet.
    What is the formula (or macro) I need?

  7. Hello!

    I have a doubt, although is not exactly about what is being discussed here... on summations in excel.
    I want to add the values of columns and rows,

    A B C
    A X 1 3
    B 2 X 8
    C 4 2 X

    To obtain: (A+B and B+A in their respective cells, etc)

    A B C
    A X 3 7
    B 3 X 10
    C 7 10 X

    I have been checking how but haven't found yet. The problem is that I have huge matrices, that contain thousands of values, so I can't really do by hand one by one, plus I can make errors continously due to mistaking lines...It would take me weeks...

    Could anyone tell me how to get this in an automatic way?

    Thank you very much!

    Best reagards,

    miguel

  8. I think this should be easy, but I can't seem to find a solution. If I have a cell that contains "=SUM(C9:C14)", what's the best way to automatically color fill all of the cells in that range? Similar to Crtl-[ but automatic. Thank you.

  9. Could somebody help me in finding a formula that suits my needs? Through using conditional formatting, I used the highlight cell rule if it has text that contains key words. I want a formula to highlight the row in the same colour as the key word column. E.g. if cells in column c contain the word Apple, highlight the cells green. If cells C8 and C12 contain that word, I then want those two rows (8 and 12) to highlight green. I apologise if the answer's really obvious, I'm just really stuck!

    1. Hi Yasemin,

      Please try to do the following:
      1. Select cells with your data.
      3. Click Conditional Formatting -> New Rule.
      4. Select the "Use a formula to determine which cells to format".
      5. In the Formula field type the following formula:
      =NOT(ISERROR(SEARCH("Apple", $C1)))
      6. Click the Format button to set the format you need.
      7. Click OK.

  10. hiii

    sir/madam

    i have to sum

    1200 cft (i have to mention amount & Measurment both in each sales )
    1300 cft
    1400 cft
    total---------?

    please inform me

  11. kako u excelu dobijene vrednosti zaokruziti na 5 ili 9
    npr. 27,2 =25 ili 27,6 =29

    1. Hi benito,

      You should use the following formula:
      =IF(MOD(A1, 5) >= 2.5, QUOTIENT(A1, 5) * 5 + 4, QUOTIENT(A1, 5) * 5)

  12. kako u excelu dobijene vrednosti zaokruziti na 5 ili 9
    npr. 27,2 =25 ili 27,6 =29

  13. if i want get a sum of cells data in a column (if it is in time format like 7:30, 1:45 what is the method please ?

    if i do it normal way it calculates up to 24:00 and total is a wrong figure ?

  14. how to do outstanding amount. example: 1+1+1 total = 3 outstanding 0

    pLease advice

  15. Is there a way to total the sums of only the highlighted cells in a spreadsheet? I accrue my expenses for each of my jobs and then highlight when the expense is received so it would be nice to be able to determine what expenses have been received already.

  16. i want to count total 10 cell in single short i am using sum formula, my problem is in between 2 cell have a formula that 2 cell values not count in total how to count 10 cell

  17. Good Afternoon, I wanted to know how do I capture all the total in line C.To add all totals together. I know I click on each total with the plus sign. It's just not working can you tell me what other keys I need to hold. Thanks

  18. Please help my on this formula
    I want every cell in the row more than 60 to give me the difference otherwise if it is 60 than give me a 0
    My formula looks like:
    =IF('TOTAL WEEK 1'!$D$4:$R$4>60;'TOTAL WEEK 1'!$D$4:$R$4-60;0)
    But if give me only a result if it is more in the first cell not in the following cells .
    Thank you in advance

  19. بسم الله الرّحمن الرّحیم
    hello
    thank you very much.
    It,s very good....

  20. How can you get the AutoSum of all fill column blocks.

  21. Hi, Is there any way to change for example =4+4+5+6 to column like
    4
    4
    5
    6

    Regards

    1. Hi Rawa,

      First you need to use the Excel Text to Columns option to get the numbers in separate cells. Then use Paste Special -> Transpose.

  22. when I insert data into columns and press auto sum, i get the total. But when I delete the data from one of the column, the total still remains the same. It doesn't change. How do i rectify this problem?

  23. Amanda,

    The semi-manual approach to assist manual deletion would be to use Auto Filter or Sort to display sorted lists sorted by column C, then column B (where C is the same) then column A (where the previous two are the same), then column D (where all are the same). This way you get a block of rows with Jane, Smith, Excel Training Basics, Date and can keep the latest date and delete the rest.

    The automated way would be to insert a new Worksheet to show the latest training only, leaving previous training on your existing Worksheet, say "Sheet1". You could then write a Visual Basic macro to copy rows from "Sheet1" into your new sheet, sort them and find the most recent dates of each instance where A, B, and C match up. Recording a macro where you manually invoke the appropriate Copy and Sort will help you see which functions to call to automate it, but it's hardly a beginner's task.

    1. Congratulations to you, am former. computer study I enjoyed the program of ISU

  24. Hi, Svetlana,

    I'm a bit stuck on finding a formula that will suit my needs. My spreadsheet has column A: first name; column B: last name; column C: type of training; column D: date of training.

    I need a formula that will look at column A, B, and C and if they match any other row in column A, B, and C I need it to select the most recent date.

    this will remove all duplicate training and keep only their most current training record.

    Any suggestions? i'm stumped on this one.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)