function disregard hidden rows?

G

Geo

is there a way to force a function to NOT include the
hidden rows when calculating functions such as slope and
intercept?

I know SUBTOTAL works this way, but I'd really like to be
able to use some of the other stat functions as well.
 

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

How to make scroll bar permanently visible, Word 365 0
Descenders clipped 0
Can you subtotal data in rows? 8
Problem with LARGE function 3
Setting intercept to zero with SLOPE/STEYX/etc 3
deming excel function 1
How to ignore hidden columns 3
Hidden cells 1

Top