Excel Sum Function Examples Part 3

Sum cells that match multiple criteria - SUMPRODUCT

Sum the Top 5 Numbers in a List

Sum Amounts in a Date Range

Part 4

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel Sum Function Examples Part 1

Sum a range of cells -- SUM Function

Grand Total a range of cells

Running Total for a Range of Cells

Sum a range of cells -- OFFSET

Part 2

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel Sum Function Examples Part 2

Sum cells that match criteria -- SUMIF

Sum cells that match multiple criteria -- SUMIFS

SUMIFS With Multiple AND/OR Criteria 

Part 3

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel Sum Function Examples Part 4

Sum a Filtered List With SUBTOTAL

Sum a Filtered List With AGGREGATE

Sum Specific Items in a Filtered List

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel Scroll Bar Christmas Tree Example

Introduction to the Excel Scroll Bar

Create a Christmas Tree Picture

Create Named Ranges

Number the Hidden Items

Create the Message List

Add the Scroll Bar

Create the VLookup Formula

Add the Text Box

Add the Conditional Formatting

Test the Scroll Bar

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London