Tom’s Tutorials For Excel: Selecting Functions From the SUM icon’s Drop-Down List As the pictures show, you can click the small drop-down arrow to the immediate right of the SUM icon for a list of other functions to select. As … Continue reading →

Tom’s Tutorials For Excel: Conditional SUM of Alphanumeric Data Here’s another crazy example — but it happens — when you are faced with making mathematical sense of numbers within alphanumeric data. This example shows how to sum numbers that follow … Continue reading →

Tom’s Tutorials For Excel: Handling Multiple OR Lookup Criteria When you are faced with a LOOKUP task and the possibilities require too many nested “OR” operations, consider an array constant in your formula. In the picture, a company is grouping … Continue reading →

Tom’s Tutorials For Excel: Deselecting All Embedded OptionButtons and CheckBoxes If you have embedded OptionButtons or CheckBoxes onto your worksheet from the ActiveX Toolbox or the Forms toolbar, here are two macros for examples of how to deselect those controls. … Continue reading →

Tom’s Tutorials For Excel: Copying Multiple ListBox Selections to Worksheet Here’s how to transfer multiple selected items from an ActiveX ListBox onto your spreadsheet without intervening empty cells. Private Sub cmdConfirm_Click() ‘Turn off ScreenUpdating. Application.ScreenUpdating = False ‘Declare variables for … Continue reading →

Tom’s Tutorials For Excel: Summing to Today’s Date With INDIRECT Here’s an example of using the INDIRECT and SUM functions to add numbers from the top of column B to the row where today’s date (or whatever date you specify) … Continue reading →

Tom’s Tutorials For Excel: SUMIF For Days Past Last Date Here’s an example of two formulas working in tandem for a common goal. In cell E1 is the formula =LOOKUP(9.99999999999999E+307,A:A) which returns the last number (in this case a date) … Continue reading →

Tom’s Tutorials For Excel: Horizontal SUMPRODUCT Just a quick example of the SUMPRODUCT function being utilized for data arranged horizontally across a row, instead of the more usually-seen columnar arrangement. The formula in cell B12 is =SUMPRODUCT((A7:L7=B10)*(A8:L8>=B11)) The formula in … Continue reading →