total columns data

  1. S

    How do I populate a field with the sum of a range of fields?

    I'm helping to edit an expense report sheet. I have drop down tabs to categorize the expenses, however I was instructed to find a way to have each grouping's sum total automatically repopulate in a category subtotals partition on the same sheet. I've looked at a variety of functions that only...
  2. R

    Formula for text

    Hi - I am wanting to work out the total of rows with data in a particlar column. These rows do not have #'s in them (just text), so the outcome is simply a total of rows with data. If anyone could help, I'd appreciate it. I have various book lists, and am wanting a quick total of how many...

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