SMART SUM Techniques in MS #Excel 1. Multiple Ranges Totals - Filter (Select Total) - Go to Special (Home Tab) - Visible Cells Only - then ALT = for SUM (Excel will apply Subtotal) 2. Grand Total - Top to Bottom Approach Additional Tip: IF in case some rows need to be hide and want to exclude the amount from Totals then use FIND & REPLACE for Subtotal(9 to Subtotal(109 Thanks! | Excel Basement

Here's an introductory example on how to use the awesome =FITLER function in Excel to return an array of multiple values based on 1 or more criteria. FILTER is really powerful and can be used in combination with other functions to make it really dynamic in your workflows. I'll be posting lots more intermediate-advanced examples of FILTER soon! #Excel #analyst #data #exceltips 💻 | Excelwithkyle23