Installing Windows 11 on devices that don't meet minimum system requirements. If you changed your hardware in order to upgrade to Windows 11 and the system is not recognizing the change in a timely manner, this article explains how to initiate the assessment manually.

The SUBTOTAL function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. For example, when you subtotal a horizontal range using a function_num of 101 or greater, such as SUBTOTAL (109,B2:G2), hiding a column does not affect the subtotal.