Tips: You can also apply these functions by clicking Kutools > Kutools Functions > Statistical & Math > AVERAGEVISIBLE / COUNTVISIBLE / SUMVISIBLE as you need. Sum the filtered cells: =SUMVISIBLE(C6:C19) Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.Īfter installing Kutools for Excel, please enter the following formulas to count or sum the filtered cells:Ĭount the filtered cells: =COUNTVISIBLE(C6:C19) If you have Kutools for Excel, the Countvisible and Sumvisible functions also can help you to count and sum the filtered cells at once. To sum the cell values based on the filtered data, apply this formula: =SUBTOTAL(9, C6:C19) ( C6:C19 is the data range which is filtered you want to sum), and then press Enter key. To count the cells from the filtered data, apply this formula: =SUBTOTAL(3, C6:C19) ( C6:C19 is the data range which is filtered you want to count from), and then press Enter key. The following formulas can help you to count or sum the filtered cell values quickly and easily, please do as this:
To count or sum cells based on filter or filter with criteria, this article may do you a favor.Ĭount / Sum cells based on filter with formulasĬount / Sum cells based on filter with Kutools for ExcelĬount / Sum cells based on filter with certain criteria by using formulas How to count / sum cells based on filter with criteria in Excel?Īctually, in Excel, we can quickly count and sum the cells with COUNTA and SUM function in a normal data range, but these function will not work correctly in filtered situation.
0 kommentar(er)
