autosum

  1. M

    Excel Formula help

    The data on the left are the invoices Data on right side are the receipts I need to allocate the receipt against invoices and where there is partial payment the adjustment will come from second payment Secondly I also need to identify the invoices are adjusted against which receipt so each...
  2. K

    Sum formula does not provide the same outcome as AutoSum

    Hello, I have time formatted as hh:mm, when I highlight all of it, the AUTOSUM in the bottom right corner of Excel is correct. The total is 61:46 or 61 hours and 46 mins. However, when I try to use a formula to do the same outcome =SUM, the end result is 13:46, my time format in that cell is the...
  3. M

    Dynamic AutoSum

    Hello, I am looking to do a Dynamic AutoSum function in VBA. Here is my code: Rows(1).Find(what:="Qty $", lookat:=xlWhole).Select LstRow = Cells(Rows.Count, ActiveCell.Column).End(xlUp).Row + 1 Cells(LstRow, ActiveCell.Column).Formula = "=SUM(ActiveCell:ActiveCell.Column" & LstRow - 1 & ")"...
  4. C

    Cycle multiple Excel functions in single macro

    I am trying to create two macros and would really appreciate some help on this, as not sure where to begin. 1. AutoSum Min on first execute then AutoSum Max on second execute (if the macro is executed in the same cell). Then beyond the second execute, the macro should cycle through these two...
  5. A

    Automated Autosum

    Hi I would like to seek some advice on how I can do the following. I have a macro(I use a do while loop to check and insert the extra row) that sorts out data in a certain format by inserting a line(row) in between 2 rows effectively separating the data set. After running my macro, I am...
  6. I

    Autosum & Msgbox

    Hi, I have this code supplied below in place but need advice please. I would like to include the autosum shown below into it. Worksheet is called DATABASE The range would be O5:O179 As info is added to the DATABASE worksheet the 179 then becomes 180,181,182 etc etc Many thanks. Private...
  7. A

    A Little Help with AutoSum

    I'm not the most proficient with Excel, so please be patient. In a nutshell, I have inserted an IF statement in a cell like this: =IF(E64="Resize","5","10") As a result, if I type in "Resize" into one cell, it autogenerates a 5 in the adjacent cell. If I type anything else, it places a 10. So...
  8. K

    Macro/VBA help. Insert Sum() to bottom of numbers, continuously in column, till end.

    Hi Everyone, I need some help to try to overcome this time consuming task in excel. I hope someone here can help. I have a worksheet that I'm working on, which I have to insert a Sum() Function to the bottom of some numbers in a column to give me the total. (Im working on a single...
  9. J

    Autosum using the last row from another column vba

    Hi all, I'm looking to place an autosum function via vba into my worksheet. I am wanting the values to select all cells from F3 down to the last row of data that appears in the A column. For example if the last cell containing data in column A was A6 then I would want the autosum function to...
  10. M

    Autosum every certain rows

    Hello everyone, I am looking for a way to run this macro on a determined starting point not only on "m3137" but for example if I am in "A3194". It may be worth to mention that I added blank rows to make navigation easier and to have a cell to do the sum. This is the code I used: Sub...
  11. M

    Autosum at an empty cell in column. Only autosum for visible cells!

    Hi guys. I have a data sheet which is attached here. I get a new data sheet like this every day, and that is why i need it to autosum where the red arrows are pointing in the attached picture. I've used filter so i only need it for the visible cells. I have this macro; Sub AutoSum() Dim Area...
  12. C

    AutoSum Error

    Hey everyone, I'm having an issue and I have no idea why it's happening. I currently have a pretty large macro running, but at one part it's supposed to find the last row, autosum the contents, add the word "Total" to the first column and delete anything in the second column. Here's the...
  13. S

    autosum and find percentage

    I am in need of some help with this one. I need a macro that will autosum column I, and then multiple by 5%. The tricky part is not every row has data. I am using this sheet copy/pasting data into a estimated price excel. Not every item has a predefined price, and comes up as N/A. When I...
  14. J

    VBA AutoFill formula to adjacent cells

    I have a report that returns a variable amount of rows depending on the number of transactions returned. I have my cursor located in the last occupied cell in Col. "F", which contains an AutoSum formula. This formula needs to be copied to the next 5 cells to the right (along with the...
  15. J

    Sum dynamic number of rows using vba

    Sometimes the easiest problem is hard to solve. I have a report that returns a dynamic number of rows depending on the volume of transactions. I already have code that takes me to the first blank cell in Col. "F": Range("A" & Rows.Count).End(xlUp).Offset(1, 5).Select Now i need to basically...
  16. A

    Autosum table column

    Hi... My current activecell is one of the cells in the Totals row in a table, i have so many tables with different row count so the "FormulaR1C1" method is not working for me cause each time the values are different, i am looking for a code to enable me to autosum the whole column of the table...
  17. A

    Autosum Current column in a table

    Hi everyone... I selected a specific range in the Totals Row in a table and i need to either: 1. Autosum this column without reference to cell maybe something like application.activecell.autosum or 2. Autosum current table column Thank you...:)
  18. J

    Applying Autosum multiple times in one column with varying numbers of lines

    Hi. I have a set of data where I have to add in multiple subtotals but I can't use the subtotal function for a couple of reasons. Basically I have data like this: <tbody> 10 20 15 10 10 11 11 10 15 20 35 50 15 15 15 </tbody> And everywhere there...
  19. Z

    Macro Sum each column across several columns

    I need help simplifying this code. I need to find the last row with data based on column G, then need to sum and drag this sum formula across columns G:M. I am essentially trying to create a totals row. It would be nice to also add a bold border above the row. I know this code is clunky, so...
  20. J

    Macro

    Hi, I am not brilliant with coding so apologies if this seems really simple. Within our FoxPro based system we have an export to excel feature which currently exports data to a csv format. What I am hoping to do is create a macro that will insert a new line into row 1 (moving the data down a...

Some videos you may like

This Week's Hot Topics

Top