sum column

  1. J

    Auto Insert Row & Sum the Above Cells Excel Macro

    In my Excel sheet I have values from Column A to Q. Column A is the Serial number Such as 1 2 3.....starting values from A6 as 1. Column G is filled in without having Blank rows. Example Column A6 is 1 & Again column A8 is 2. Hence I want to insert a Row in 8th row & will have a Text TOTAL in...
  2. C

    How to SUM a column with multiple entries in a single cell

    Good Morning, I am new to this forum and a little bit new to Excel 2007. I am struggling to come up with a formula to SUM a column with multiple entries in a single cell where other cells have single entries. The values i require are costing therefore £ values in each column require to be...
  3. B

    Sum range of cells in active cell

    I have a report that comes out daily and has a different number of rows each day. I need to have the vba code that will calculate the sum for a range of cells. The first cell should always be Q4. I have used auto fill to copy a formula down using Range("Q4:Q" & lastRow), but I'm not sure how...
  4. A

    Conditionnal Sum

    Hello, Here is what I have : A B 2 - 4 5 5 - 6 7 What I need to do is a sum of the column A if <>#N/A" and "<>#DIV/0! And In case the cell value B is not blank, replace the value in the corresponding A cell with the B cell value In this case A column sum is 17 the sum I want is 19 Could...
  5. M

    memory-friendly summing of dynamic columns?

    Hello, I have a 'data' worksheet full of raw data, including one column, let's say column AE, that is the 'net amount' column. For various reasons, I need to keep a running total of this column displayed on another worksheet. So far I have been doing this with the formula: =SUM(Data!AE:AE)...
  6. J

    VBA to insert Totals row in table

    Hi All, My problem is I am creating a invoice which is being exported from access to excel, which basically needs all the items and their price and then the overall total. I just want to insert a row which has the total for the price column. Alternatively I could do a SUM calculation in...
  7. A

    Sum Column below until...

    I am trying to use a forumula that can sum a column until a certain point, which is when a non adjacent column's information is filled in. And then I want it to repeat. For example: Cells A1: has text, Cells E1-1000 has numbers Cells A2-8: has blanks Cells A9: has text And perhaps Cells...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top