1. tourless

    VBA Insert SUM formula not result of SUM

    Hi Folks, I have invoice data separated with blank lines between invoice numbers and I'm currently using the following code which gives me the result of summing up the line items of a given invoice and it works fine. But what I would like to do is actually insert the sum formula for the rows...
  2. D

    Sum if Question

    I'm not sure if this is possible, however I am trying to sum a row, but if the sum value drops below a 0 it should just be 0. If it's a positive, it should return the value of the row. =IF(A3="","",SUM(B3:C3))+D2 It's a daily continuing total so I just added the day before to the next day if...
  3. B

    Generating random numbers / Sum with a command button

    Hi, I need to create a code that will generate random numbers at the click of a command button "start" until the person click another command button "stop"..... the numbers will appear on the form and once stopped, it will provide the overall sum of all numbers generated can someone help me...
  4. A

    VBA Code for Summing Data Above total until a blank row

    Hi All, I'm working on a project to automate a manual process currently in place and am struggling with one piece of the macro puzzle. I have a spreadsheet with data across several columns and rows, separated by a blank row with totals underneath each data category. The totals are generated by...
  5. C

    Complete my formula...if function with multiple criteria (or alternative ideas)

    Please can someone correct my formula, I feel like I am so close but struggling to get it right. Below is as far as I have got but I just cant find the right expressions for it to work correctly. I have attached a picture of the document I am working with for your reference...
  6. M

    Sum and Match Combined

    Hi, I want to sum rows using the match function. I need the match function to figure out what row to sum based on the value in column A then skip 2 columns and sum row X columns D-F. Any ideas? Below is an example. Column A Column B Column C Column D Column E Column F Row 1 # Street...
  7. O

    Sum Monthly Data to Quarterly

    Trying to Sum monthly data from a column in a different sheet to a quarterly output in a row on my summary page. Anybody know of a formula that I could use to do this? Thanks!
  8. C

    Month Sum based and dates and a name

    I have a spreadsheet called "Scrap Detail" where we log what items we scrap and against what work cell. Column A has the date and column B has a drop down to select the Cell. The value of the scrap is then totalled in Column F. We then have different work cells within the business where I have...
  9. S

    Calculating ending balances (sum with several conditions)

    The example with notes about problem is attached. Shortly: I want to automatically calculate ending balances from small general ledger I keep in excel. The formula should understand what account we are speaking of, what month is the transaction from and is the column debit or credit. I hope...
  10. D

    Excel isn't calculating as it should

    I'm building a spreadsheet for running the asset list, it calculates monthly depreciation and builds the accounts journal. Its under 1Mb of data. There are various formulas going on, simple SUM to SUMIFS but very few VLOOKUP. I entered a SUM to add up a column, the result was £0. ISNUMBER...
  11. K

    SUMIF where range and sum_range are in every nth column

    Hello! I would like to get result of 19 in B7 for sum up values where criteria is always banana (A7) but there are multiple ranges(A,E,I) and sum_ranges(C,G,K) which are in every nth column. A B C D E F G H I J K 1 apple n/a 1 cherry n/a 1 banana n/a 10 2 banana n/a...
  12. F

    Sum of highest 4 consecutive numbers and define the 4 numbers

    Hi everyone. I have a number spreadsheet with 20 columns /100 rows of numbers. I need to get the sum of the highest 4 CONSECUTIVE numbers of each columns. I have found two formula to get the sum: =SUMPRODUCT(MAX(D3:D95+D4:D96+D5:D97+D6:D98)) or =MAX(INDEX(D3:D95+D4:D96+D5:D97+D6:D98,0))...
  13. masud8956

    Progressive summing basing on cell value of another column

    Hi, I have a range of numbers at A2:A10. Column B shows the progressive sum (e.g. B2=A2, B3=B2+A3, B4=B3+A4 etc). Column C will either be blank or have a certain text "ABC". I would like the progressive sum result at column D instead of B with some criteria. I need a formula at D2 which I can...
  14. A

    Sum Multiple Columns Index Match Matrix

    How can I write a formula that will sum the value from multiple columns using an index match matrix based approach? The formula below will work when there is only one column that has the "OC_TECH" value, but I want to sum both values if "OC_TECH" occurs as a column header more than once. for...
  15. L

    Sum if Question

    I have a list of employees in Column A (some employees are listed multiple times), Column B is the date, and Column H is a points total. Column P I have a unique sorted list of each employee. I would like Column Q to show to sum of points for each employee from column H. I am not sure how to...
  16. S

    Difference between summary column in PIVOT

    Good Morning We have employee advance and their repayment details in excel. Each advance having one row with employee no, name, date, advance_amount Each Receive(Repayment) having one row with Employee no, name, date and repayment_amount Now we made PIVOT with employee name , sum of...
  17. T


    Hi I am currently using this formula. =IFERROR(INDEX(Transfers!$J$5:$J$999999,MATCH(A68&$A$61,Transfers!$F$5:$F$999999&Transfers!$H$5:$H$999999,0),MATCH($A$3,Transfers!$E$5:$E$999999,0)),0) It works great except it does not sum multiple matches it only find the first match in the table. I need...
  18. C

    Keeping Adding 3 to a Sum

    I'm trying to figure out how to add 1 + 3 and then keep adding three to the sum? I am curious how to make that work, I've tried all kinds of formulas and now I just want to know to know. 1+3 = 4 then 4+3 = 7 I want to keep it running..
  19. M

    VBA - Sum Non Contiguous Columns range.

    Hi Team, I want to sum Non Contiguous Columns range. Is it possible sum Below formula in a Single formula. Need help in R1C1 styles sum. Range("A6").FormulaR1C1 = "=sum(R[-4]C[0]:R[-1]C[0])" Range("C6").FormulaR1C1 = "=sum(R[-4]C[0]:R[-1]C[0])" Range("E6").FormulaR1C1 =...
  20. tamrob23

    SUM or IF formula for replacement?

    I'm stuck in my own head - hopefully you can get me out: I have a budget of $1.6 million dollars, but the state is doing a $2 million dollar budget. Can you please help me with a formula that will show the $1.6M replaced with $2M? Thank you so much in advance and if I need to provide you with...

Some videos you may like

This Week's Hot Topics