Sum visible rows in a filtered list

An excel formula to sum visible rows in a filtered list

Related Functions

Sponsored Link

 Sum visible rows in a filtered list
=SUBTOTAL(9,range)

If you want to sum only the visible rows in a filtered list (i.e. only those rows not filtered out), you can use the SUBTOTAL function. What makes SUBTOTAL especially useful is that it automatically ignores rows that are hidden in a filtered list or table.

Following the example in the screen above, to sum cells in column F for visible rows only, use:

 
=SUBTOTAL(9,F5:F14)

If you are hiding rows manually (i.e. right-click, Hide), use this version instead:

 
=SUBTOTAL(109,F5:F14)

The SUBTOTAL function can perform many other calculations, like COUNT, SUM, MAX, MIN, and more. (See the full list here).

Sponsored Link

0 votes. 0 / 5