Click the button below to download an Excel Workbook for the Candy Sales HLOOKUP, VLOOKUP, COUNTIF, COUNTIFS, SUMIF, and SUMIFS walkthrough. Source video is “Excel Tutorial: VLOOKUP, HLOOKUP, SUMIF, SUMIFS. COUNTIF, & COUNTIFS Explained In 15 Minutes”