No products in the cart.

What is the purpose of 'Subtotal'?

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

What is the purpose of 'Subtotal'?
  • 1 answers

Meghna Thapar 3 years, 10 months ago

The SUBTOTAL function ignores any rows that are not included in the result of a filter, no matter which function_num value you use. The SUBTOTAL function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. Anything before the absolute end sum, such as before the taxes are calculated, or the discounts are calculated, is the subtotal. The amount actually paid is the total, not the subtotal.

http://mycbseguide.com/examin8/

Related Questions

Define goal seek
  • 1 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Download myCBSEguide App