Hidden Cells in formulas

  • Thread starter Thread starter Shane Faulkner
  • Start date Start date
S

Shane Faulkner

I have a formula that adds several columns of data. I'd like my
formula to ignore the values in hidden columns. As of now, all data,
including the data in the hidden columns is added. Can anyone help?
 
You must log in or register to reply here.

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

lastrow function help 6
Mid column sum formulas with varied ranges to sum 17
Set Find to look in Values instead of Formulas by default? 3
Hide column based on data validation 0
Making Find ignore parts of a sheet? 4
Changing a csv file opened as hidden workbook 13
Conditional Formatting with VBA 4
Excel Help to copy information from one row at a time to another sheet 1

Back
Top