sum a row

  1. K

    Dynamic SUM Range

    Hi All. I want to SUM a 12 month range of numbers starting with the first month that has a number >0, and to start a new SUM range from the month following the previous SUM range. For instance in the calendar year 2023, if April is the first month with a number >0, that would be the starting...
  2. U

    Excel VBA: Combine Row Data of Specific Accounts

    Hi Gurus, Good day! I just want to consult if there's a VBA way to combine the data (get the sum) of specific accounts? For example I have long list of data but need to combine the total data for Math & Science. Note that there are negative numbers sometimes and Reference 01 is the main...
  3. P

    SUM Function not working in 365

    QT 1g 2g 3g 5g 8g 10G 15G total 0 15 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 3 0 19 0 2 0 0 0 0 0 75 0 0 0 0 0 0 0 75 I am basically trying to find the sum of the different sizes of plants. There is a XLookup where it feeds the numbers in from a list, but the total is where I am...
  4. M

    Total Does Not Match With Sum of Values in Each Cell

    Hello, I am preparing a sheet of Stock Trading and I have entered the formulae for all the expenses related to stock purchases. Sometimes the amounts are in fraction. When I compare the values in each cell those match exactly with the statement provided by my stock dealer. However, When I take...
  5. M

    SUM problem

    I have a simple =SUM(A1:G1) formula here but it's not working. It's like it's missing column data and giving incorrect totals. Each result (A:G) is populated by an IF formula. Any thoughts why Sum would not be working properly? Auto Calculation is on, which is the only thing i can think of...
  6. W

    Conditional Format a row of values that sum up to but not over x

    I have a row of values B:W that I would like to highlight if they sum up to a value in column A. And copy that row CF to 600 rows below. A visual of how many days it took a product to sell through. <tbody> sales units 1/1/18 1/2/18 1/3/18 1/4/18 1/5/18 1/6/18 22 10 24 9 18 29 4 45 9 19...
  7. T

    Double count issue. SUMIFS/SUMIF

    Hi all, I am having a problem with a double counting sumif, because of and array. <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 232px"><col width="100"><col width="100"></colgroup><tbody> #f4f4f4[/URL]...
  8. P

    Combine rows with duplicate tag

    Hi Everyone. I'm new to excel and VBA. So maybe the question is a bit dumb. I got my macro reading different Excel file and combine as a big datasheet. I am facing problem in combining data. At First, I got 2 column and the sheet is blank. <tbody> Name Total </tbody> After I ran the...

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