ExcelBanter - sum only visable cells from a sub total

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sum only visable cells from a sub total (https://www.excelbanter.com/excel-discussion-misc-queries/241362-sum-only-visable-cells-sub-total.html)

jujuwyo

sum only visable cells from a sub total

How can I sum only visable cells after I have performed a sub total?/

Don Guillett

sum only visable cells from a sub total

Look in the help index for SUBTOTAL and read it

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jujuwyo" wrote in message
...
How can I sum only visable cells after I have performed a sub total?/

All times are GMT +1. The time now is 01:04 AM.