There are two types of number you will find while writing SUBTOTAL formula
– Single Digit: 1,2,3,4 etc.
– Three Digit: 101,102,103,104 etc.
But if you see these number screen tips, you will realize that these are using the same function. Ever wondered why. Here is the reason:
– Single digit function number includes all values listed in the range for selected calculation including hidden cells, however consider only visible values in filtered list
– Three digit function number includes only visible values listed in the range for selected calculation and avoids hidden cells irrespective of filtered list or hidden rows
So three digit function number is more useful than Single digit number. Here you go for detailed listing: