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:
Win 8.1: Disk usage 100% in task manager
Modify MP3 Encoding Rates in Window Media Player Rip CD Function
How to configure SSL in Outlook Express
How to disable auto start for Windows Live Messenger
How to flush DNS cache in Linux / Windows / Mac
How to auto start Chrome in Full Screen Mode (F11) everytime
Disable Recent Documents History to get full privacy
Win 8.1: How to enable Libraries in sidebar
Share this with your friends:-