Summing only values in visible columns, not in hidden columns

G

Guest

I need to write a SUM function that will add up several cells in a row (for
example, A4:S4) - but I only want it to add up the values in those columns
that are visible, not the values in those columns that are hidden. Is there
any way to add only values in the visible columns and not the hidden ones?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing visible column values but not hidden column values 2
Sum visible cells only 8
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied 3
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Display columns or rows based on values 1
Comments partially hidden due to "frozen" columns 2
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
organizing rows and columns by text 1

Top