# Average

# Count

By using the COUNTIF function:

- Count cells/ values if greater than
- Count cells if equal to
- Count cells if end with
- Count cells that begin with
- Count cells that do not contain
- Count cells if contain negative numbers
- Count cells if contain positive numbers
- Count cells that contain [n] characters
- Count all characters of several cells

By using the COUNTBLANK function:

- Count cells that are empty from a selected range.

# Date

Restrict date to be entered and cell should only accept desired date (e.g Friday only)

# Depreciation

Calculate depreciation for the first month

# Min & Max

Minimum value from a set of values.

# Round

# SUM

by using SUM function:

- Calculate running total
- Sum by text
- Subtotal by invoice number
- Subtotal invoices by age (datewise)
- Sum by groups in columns
- SUMPRODUCT Function (Multiply corresponding arrays, then return with the sum)
- Sum by month
- Sum visible rows only
- 3D Sum for multiple worksheets
- Sum entire column or row
- Sum if not blank
- Sum if cells contain specific cells
- Sum against single criteria in multiple columns
- Sum if less than
- Sum if cells contain two specific texts (e.g. x and y)
- Sum between dates
- Sum if cells contain an asterisk “*”
- Sum if ends with
- Sum top n values
- Sum bottom n values
- Sum if equals to many things
- Using the SUM function along with the OFFSET function

By using SUMIFS function:

## Logical

Return different values based on condition e.g. student’s result based on numbers obtained

## Data Analysis

Create dependent drop-down lists