sum = 0

  1. M

    Pivot Table Not Returning Sum, Only Returns "0"

    I am trying to simplify a horrible and old spreadsheet for attendance tracking (there is a worksheet for every employee, SMH). I am moving everything to a new spreadsheet to just be on one sheet with all of the data, and a pivot table to display the count of types of occurrences, and another...
  2. U

    Macro Create Sum and Separate Zeroes

    Hi Guys, Can you possibly help me clean up below codes? The range of cells with data is from A:AD 1. Basically starting in AG5, I will create a sum formula from E5:T5 which will be copied down to the last non blank cell (not just till range 681). 2. The macro will hardcode the sum column and...
  3. C

    Sum Function Calculating Incorrect Sums and Sometimes Returning 0

    I have researched and even attempted other suggested fixes for this problem, but am still unable to find what I'm doing wrong here. I have been working on forecasting our clinic system physicians' encounter numbers for the next year and wanted to sum all of the physicians' counts for the...
  4. W

    sum function returns 0

    on an existing spreadsheet, the sum function is returning a 0 value. Cells that are being added together are formatted as numbers. No matter how the sum function is written, or a if working formula is copied to this cell, the answer is always 0. We have tried closing the sheet and re-opening...
  5. B

    Formula = 0 after trying to trace/correct circular reference

    Ok this is weird. I had a circular reference error when I opened my workbook this morning. I have been trying to trace where it is coming from to get rid of the "#REF" everywhere. I was able to delete and recreate formulas but now I have a group of cells (where I believe the original error was...

Watch MrExcel Video

This Week's Hot Topics

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
Top