summing cells

  1. S

    How To Construct a SUM formula

    Hi, I am looking at writing a formula to sum values of a calendar (columns in months) up to a certain period in that calendar - and would like for it to generically work without having to update the ranges in a formula each month etc. Below is a pict of the data - for ID = A, the formula sits...
  2. E

    Summing Multiple Sums Formulas

    I have a data set that has sums for various groups within the same column, so row 1-10 will have data and row 11 will have a sum for the above numbers. Then I will have rows 12-15 with numbers and a sum formula for the data in rows 12-15, etc etc. Is there a formula that I can use to only sum...
  3. S

    Help - Summing With a Many to Many Relationship

    Can someone kindly help me, I am so stuck! My boss made a workplan in Excel and we want to sum the number of hours each person has of work in a month across all tasks. The output table should show something like this <tbody> Name Jan Feb Mar Person 1 4 2 Person 2 1 7 55 </tbody> The...
  4. M

    Nth cell in a row being summed

    I have Jun Medical - Jun RX - Jun Vision - Jul Medical - Jul RX - Jul Vision $120 10 30 120 20 35 I need to add all Medical then all RX Then all vison

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