I'm betting that your friend's data has data|filter|autofilter applied and is
filtering that range.

That autosum button is pretty darn smart!

rfIPS wrote:

For some reason, when one of my users hits the Autosum button, it performs a
subtotal instead. Does anyone know how to fix this?

thx!

--

Dave Peterson