In Excel, SUM() function is being used to sum a range of row data. However, it’s not able to sum filtered rows. But no worry, excel provide another function to solve this problem. You may try to use subtotal() to sum up all the filtered rows.
To sum filtered only rows in Excel, use the functions below:-
Advertisements
- You have to use subtotal() function with 109 as 1st argument and range as 2nd argument
- For instance, to sum filtered row from C1 to C20, you may key in the formula below in an empty cell:-
=SUBTOTAL(109,C1:C20)
Related posts:
How to uninstall Internet Explorer 8 (IE8) in Vista
How to screenshot in Window 8.1?
How to open .mdi file in Ms Office 2007
How to Specify Default Download Directory in Internet Explorer
How to Backup Outlook Express email
How to perform email compact in Outlook 2007
Win 8: How to add folder shortcut at Favorite in Window File Explorer
How to open .iso file on Ms Windows?
Share this with your friends:-