sum columns

  1. J

    Sum 2 columns on every Ws (except 3)and if they are equal to each other change their fill color

    I need to get my code to Sum 2 columns on every Ws and if they are equal to each other change their fill color. i need to do this for 40 sheets but i have 3 sheets this doesnt need to happen for. My current code only does the Sum for the active sheet i am on and i havent been able to get the...
    • JakariKryze
    • Thread
    • change fill color exclude certain sheets loop through worksheets sum columns
    • Replies: 3
    • Forum: Excel Questions
  2. J

    Easier way to sum columnar calculations

    Hi - quick question. Is there an better way to sum all rows for col-A * col-D other than the two ways I list below? By better, I mean both easier to enter, manually as a formula below the data, and possible faster, as far as clock ticks (do any methods calculate faster, basically). I can...
  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. T

    VBA code that sums column "C" in all active worksheets

    Hello, Basically what is happening with my code is I create many worksheets which have a dollar amounts in column C of each worksheet. The code sums the column C in the first worksheet - e.g. sum of column C is 15 for worksheet 1 - and it will display a message box with total 15, it then...

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