1. I

    SUM if Row+Column > X

    hi guys, I'm having a little brain freeze here I would like sum values in cross table xy based on sum of x and y. <tbody> 1 2 3 4 1 0.10 0.12 0.25 0.30 2 0.05 0.10 0.32 0.40 3 0.14 0.13 0.10 0.15 4 0.18 0.11 0.16 0.21 </tbody> For example: sum values if Column + Row >7.5. We...
  2. S

    Delete rows if condition met without using filter

    I wanna select rows and delete them without using filter. The reason is that the Model No. is common but customer code is different and sum of required qty. is also different. So i want to keep only those customer code rows which sum is greater than other customer code rows. I have a very large...
  3. S

    Product + Sum (if)

    It is possible to have a formula where i can add a sum to a product? And in my particular case, is it possible that the result of the cell have the sum of a value just only if there are particular conditions? MY case =PRODUCT(S15,0.3) I placed this formula in order to have the result of...
  4. B

    Sumif using a list of criteria

    I was wondering if there was a formula that I could use to sum a data file using the below columns as the lookup, I would also like to use another criteria in addition to this. I.e If any of the numbers in column A appears in raw data file, sum the respective number in another column...
  5. S

    Sum specific word in area

    Hello, I have 5 columns, all of them can contain specific word 6th column is numbers. Is it possible to take all 5 columns, find if cells contain specific word and sum the number if it does. For example here I want to sum numbers of red only : <tbody> red blue yellow 5 blue red yellow...
  6. M

    Sum values till reach sum total 8 and re sum till sum total 8 again and again

    Hello,</SPAN></SPAN> I need a formula of a VBA that can sum data of column E in the column F when sum reach at 8 restart sum to total 8 again and again. </SPAN></SPAN> Result sample...</SPAN></SPAN> <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
  7. D

    How to keep SUM formula in cell after VBA

    Hello everyone! First time post here and I am hoping someone will be able to answer a couple of issues I have been having with just starting out with VBA on excel. I have a spreadsheet that will have new info every week so the columns will stay the same, but the number of rows will vary...
  8. K

    How to find and SUM Multiple Column Data by two criteria?

    <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; } .tableizer-table th { background-color: #104E8B ; color: #FFF...
  9. C

    Sum of Data based on today's month

    Hello Everyone, I have a row of sales data by month and I want to compare the sum of that row with the sum of another row of data from the same date range (ie: April-Sept 2019 total sales to April-Sept 2018 total sales), and then I want the formula to update the range of the sum when we record...
  10. A

    Sum data range if a cell in the column is blank

    Hi I have a long list of data with 10 groups, I need to sum each group when the column next to it is blank. It works fine to me when a pivot table is used but some of the sales guys don't like it. I wonder if there is a formula or macro code I can use. An example of the data range is as...
  11. H

    IF x numbers of days have passed, do this.

    Hi, I have a Table with days like this: I need a formula that if x number of days have passed it will do something. For example, if 5 days have passed since last time, "sum these two values" column A= C+D, if 5 days have passed since last time there was a value in the column: <tbody> 1...
  12. S

    SUM i to n without Using Cell References

    In excel, SUM(number 1, [number 2], ...) is used to sum an array of cells, however, I'm trying to go back to the mathematical usage of summation: n Σ f(n) = f(1) + f(2) + ... + f(n-1) + f(n) i = 1 I'm trying to use this to plug in values to a function such as PV(i%, n,, F) to sum present...
  13. S

    Sum from sheets name based on another cell valu

    Hi I have Key & sheet names in Sheet1 & key(with Concatenate) need to vlookup with Key in another sheets & get the Sheet Name & sum the column values.
  14. F

    Sum numbers using two row and sum the numbers greater then 0 using row 1 as the default

    I have row 1 (2019) totals Row 2 (2018) totals. Row 2 has all 12 months worth of data. Row 1 has 9 months worth of data. I need the sum of all 9 months in row 1 and the last 3 of row 2. That easy enough. Now when I collect the totals for the 10th month of row 1 I then need the total for...
  15. G

    Getting sum total based on date input

    Hi, Im trying to get the sum total based on the Date input at D3 here is my formula =SUM(INDIRECT("Data!"&ADDRESS(MATCH($C5,Data!B:B,0),MATCH($D$3,Data!$1:$1,0))&":"&ADDRESS(MATCH($C6,Data!B:B,0)-1,MATCH($D$3,Data!$1:$1,0)))) The problem Im facing, in this example, the Data tab is auto pulled...
  16. S

    Sum of the file in the folder

    Hello Team, i have all the files names(.xlsx) that is in the folder and currently i have to sum Column B from "sheet1" of each cell. NOTE: All the file will be closed, except the master with all the xlsx file names in the folder & in the same sheet i have the formula.
  17. C

    Pivot different columns

    Ok, so I have pivot table in which I have 2 values I need to represent. One value I have to represent by months and represent SUM, and other should be just SUM. If I put values in pivot, I can in one click present SUM of both values. OR I can separate both values by month, putting month field in...
  18. V

    Sum array then pasting it in another workbook

    The formula I have is the following: Inarr: Range("A1:J57") With Workbook("book.xlsx").Worksheet("All") loLastRow = .Cells(Rows.Count, 1).End(xlUp).Row + 1 .Range("A") & loLastRow) inarr(43, 7) So thats great for single cells. Now I have to take cells E13:E21 + E23:E31, sum them and then paste...
  19. N

    Sum of multple values, dependant on specifc date (within broader dates)

    I need to calculate the sum of specific cells, only when the fall within a specific date range. Our data can carry across months- eg Aug 1- Sep 15, however we need to count within a speicfic month only (eg September). I have tried a variety of SUMIFS, but I can't find the magic combination to...
  20. C

    Cumulative sum with data in unequal increments

    Dear All, I would like to calculate the cumulative volume of liquid from a pipe over the period of 22 years. Data has been given on a daily basis, however in some instances this covers multiple days. The format of the native data is as follows: <tbody> DAY LIQUID RATE, M3/D CUMULATIVE...

Some videos you may like

This Week's Hot Topics