Excel Subtotal

How to Sum Only Filtered Data or Visible Cell Values in Excel

This post will guide you how to sum only visible cell values in Excel. How do I sum only visible cell values in a selected range with a formula in Excel. How to sum only visible rows when filtering data in your worksheet with VBA code in Excel. Sum Filtered Data Only with Formula Sum… read more »

How to Count And Sum Cells by Color in Excel

This post will guide you how to count and sum cells by font color or cell color in Excel. How do I sum cell values by font color with VBA code in Excel. How to sum cells by color with formula in Excel. Sum Cells by Cell Color with Filter feature Sum Cells by Cell… read more »

Count Blank or Non-blank Cells in Filtered Range

This post will guide you how to count blank or empty cells in a filtered range of cells in excel. How do I count non-blank cells in a filtered range of cells in excel. How to count blank or non-blank cells in a filtered list with SUBTOTAL function in a worksheet. Count Blank Cells If… read more »

How To Use Excel SUBTOTAL Function

This post will guide you how to use Excel SUBTOTAL function with syntax and examples in Microsoft excel. Description The Excel SUBTOTAL function returns the subtotal of the numbers in a list or database. The SUBTOTAL function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function. The… read more »

Sidebar