sum visible

  1. B

    Sum Visible Cells Only

    Hi there,I've done a search of the forum and didn't see this question anywhere. I have a spreadsheet of data with some hidden rows. I need to sum only the visible cells. Is there a quick formula to do this?Thank you for your help!
  2. S

    Help with Sum Visible Cells Only ignore errors

    Good afternoon! I am hoping to find a quick answer. I am hoping Excel 2010 is able to do this. I know I can use the =SUBTOTAL(109,AT3:AT65497) function to sum visible cells. I also know I can use the =Sum_Visible_Cells(AS4:AS60000) to sum visible cells and I can use the...

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