sums

  1. gheyman

    Sumifs were the Criteria is > 0

    =SUMIFS(qry_OnTimeDelivery_MetricData[MONTH1_DUE],qry_OnTimeDelivery_MetricData[Category],$B5,qry_OnTimeDelivery_MetricData[TAT],">"&"0") This is not working. I want to sum if the value in [TAT] is greater than 0 (zero) Or I can use a formula that sums if [TAT] is not null I tried...
  2. E

    How to calculate the median of sums ignoring zeros?

    Hello I have the formula =MEDIAN(SUM(A1,A2),SUM(A3,A4)) and I want to ignore the zeros if any of the SUMs is zero. How can I do this please? I tried =MEDIAN(IF(SUM(A1,A2)<>0,SUM(A1,A2)),IF(SUM(A3,A4)<>0,SUM(A3,A4))) entered as ARRAY but it did not work. Thanks!
  3. B

    Imported webpage data wont calculate formula's just show '0'

    Hello, Have tried a number of ways and searched for an answer to this and it's probably an easy fix. I have a web link to a page and that is working great and I have seperated the columns I want ( d and e runs scored) I wish to do sums regarding to run values in D and E but wherever I place...
  4. F

    How to calcuate YTD Sum with Quarterly/Half Inserts

    Hi there - I am working on a file where expenses are listed by month. However,within that range, there are quarterly and half sums. So the range looks like: J, F, M, Q1, A, M, J, Q2, H1, J,A, S, Q3, O, N, D, Q4, H2, FY Looking for a way to calculate year to date expenses, excluding the...
  5. E

    Need help pulling sums by month from data sheet

    Hello, and thank you for any help! My existing data sheet columns are "DATE , PART# , GOOD PARTS , REWORK , SCRAP I am trying to make a new sheet that can pull sums of GOOD PARTS, REWORK, SCRAP by month and part # from my data sheet. So on my NEW excel file I would like to have multiple...
  6. N

    Pivot Table sums

    I have 2 column with a simple formula: if A1 has "ITO" in it then B1 = 1, if A1 has "OTR" in it then C1 = 1. Thats fine, but when i add these Fields into a pivot table it sums up all the cells in B1 and C1, not just how many "1s" are in them but the sum also includes the blank cells. Basically...
  7. baitmaster

    TEXTJOIN array formula giving incorrect results

    I'm using the following array formula to create a text string that joins all numbers in a range, allowing me to compare two such ranges to see if all totals are the same: =TEXTJOIN("|",FALSE,ROUND(M27:M38,0)) which by default I expect to return the values 0|0|0|0|0|0|0|0|0|0|0|0 I have two...
  8. BrianGGG

    Array of SUMs?

    Hello. I have a simple set of numbers as below: <colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>#DAE7F5[/URL] "] B C D </thead><tbody> 73 4 5 6 74 7 8 9 75 10 11 12 76 3 2 3 </tbody> Summary I'd like to return an array of column sums rather than the...
  9. I

    Find numbers in sum (Multiple sums)

    Hello, I'm trying to find multiple numbers in sum using Excel, tried Excel solver it's working, But the drawback that you can solve one at a time and takes time +30s, What's the options available for solving multiple sums in numbers? Here's the website which i used for solver...
  10. T

    SumIF problem...

    Hi, I have made a foolish error and wondered if there was a way round it. this sums col K for certain criteria, is there a way for it to sum (col K * col H) =SUMIFS($K:$K,$J:$J,$E17,$G:$G,">="&S$5,$G:$G,"<="&EOMONTH(S$5,0)) Thanks Tom
  11. T

    Sum several colums using wildcard

    Hi, Awesome forum! I am currently working on a sheet for my small business. It is a chart used to look at current and coming expenses. The final version will look something like this (design will be done later:laugh:): In row 3 I want the sum of all "costs" within that month to be summed...
  12. J

    Formula Help

    Hi I use the following formula which works well =SUMIF(CAR!$D$43:$D$907,$B4,INDEX(CAR!$H$43:$XFD$909,,MATCH(TODAY(),CAR!$H$42:$XFD$42))) How do i add the following 2 formulas to the formula above so it sums the 3 tabs? I am hoping for a single formula...
  13. N

    5 largest sums and corresponding value

    Hi. I need help. Example Data in column A - C. Desired Results E-F. I am looking to return the 5 largest sums based on a column and return the corresponding value. Thoughts? <tbody> A B C D E F 1 FL 200 MN 700 2 TX 200 CO 500 3 FL 100 FL 400 4 FL 100 TX 400 5 MN 400 CA 200 6...
  14. R

    How do I return a value....

    ...based on a date that falls between two given dates. For example, I collected $100 on April 15 and another $200 on April 20. I need a formula that sums up all cash received in April between April 1 and April 30. Thanks!
  15. N

    VBA Need help creating a loop?

    Hi, I'm having trouble with the following question. Any help is very much appreciated. Write a loop that sums the first 10 terms for the two series below? ∞ Σ1/n n=1 ............................. ∞ Σ1/n^2 n=1
  16. H

    Macro to clear data where value sums to zero

    I have values in Col b and percentages in Col G Where the % is the same in Col G for eg 1% and the values in Col b for that % sums to zero , then the data in Col A:G to be cleared from row 3 onwards In the sample data below A2:G3 to be cleared as the % is the same and the values in Col B for...
  17. P

    Calculate the 7 letters in each of the 4 quadrants, In the draw line. Each quadrant is represented by a color The middle column is in x (lilac), we

    Calculate the 7 letters in each of the 4 quadrants, In the draw line. Each quadrant is represented by a color The middle column is in x (lilac), we also have the list Of the sums of the letters of the 4 quadrants. Objective = see that each letter has 3 possible patterns = 0,1,2...
  18. gheyman

    Add a Total Row to the bottom where the number of rows will be a variable

    I have data starting from Row 8. The Last row # will be different each time. After I run my code, which puts formulas down Column F I want to find the last row and in the next one put a formula that sums column F (Column F values will always start in Row 8) So If I have data running from F8...
  19. P

    Convert from the table of 9 sums to the line of each lottery draw

    Convert from the table of 9 sums to the line of each lottery draw http://www.mediafire.com/file/pcwdkvbbe6yqst7/pasta_sum_1a_9.xlsx
  20. B

    Generate all binary combinations with constant sums of rows and columns

    I have a problem regarding to excel binary combinations. As you see there is a matrix (Matrix 1) with the values of 1 and 0. --- represents N/A or 0. I want to get all different combinations without changing the sums. Matrix 1: <tbody> Sum --- 1 0 1 0 2 1 1 1 1 0 4 1 0 1 --- 0...

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
Back
Top