How is the formula =SUBTOTAL(9, A1:A10) different from =SUM(A1:A10) in Microsoft Excel?

Question

Computer Science · Spreadsheet Formulas

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

SUBTOTAL ignores rows that are hidden by a filter

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on Spreadsheet Formulas?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · Spreadsheet Formulas

The Dandi March, also known as the Salt Satyagraha, was led by which influential leader?

Which act formally granted independence to India, marking the end of British rule?

Who was the key figure in establishing the Indian National Congress?

Answer 1

SUBTOTAL completely ignores text cells while SUM counts them as errors

Answer 2

SUBTOTAL ignores rows that are hidden by a filter

Answer 3

SUBTOTAL returns the average instead of the sum

Answer 4

SUBTOTAL includes hidden rows that are filtered out

Related Practice Questions