Why is my Excel sheet not displaying the correct data when I use the subtotal function?

1. Check your data for any invalid values.
2. Ensure your file has the correct number of header rows.
3. Confirm you have applied the correct data type (number or text) to each column.
4. Verify hidden cells are not included in the subtotal calculation.