sum formula help

  1. D

    Help with SUM formula based on data in separate table

    Could I get some assistance on a formula that I need in cell B11 below, where I'm looking to sum the total in column B for all of the units that are categorized as "old" (i.e. what's in cell A11) based on the table in F1:H7. Excel 2013 64 bitABCDEFGH1Location1Location2Location1Location22Unit...
  2. T

    =SUM function that returns text result

    Hi, I have a spreadsheet, not written by me, that has an error checking process built into it. This works by using sub-checks to sum a range of cells which if there are no errors return 0 and if there are errors return 1. The bit I am interested in understanding, is there is an SUM...
  3. S

    SUM Formula ignoring 0 Help!!

    Hi Guys I am trying to perform a formula to sum a number of cells e.g. =sum(B5:P5), however if there is no figures in these cells I would like the cell to remain blank. Can anyone help with this please. Thanks Stephen

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