A powerful combination of aggregation and logic

# What Can I Do With SUMIF?

**Start with a Raw Data Set**

A powerful combination of aggregation and logic

**Start with a Raw Data Set**

Separate First and Last Name with the LEFT, RIGHT, FIND, and LEN functions

Text data in a spreadsheet rarely comes to you in the format you need.

First and last names are combined or the company name is only available through a customer’s email address.

An explanation of the common spreadsheet Logic Functions

**IF** [this expression evaluates to true]

**THEN** [return this value]

**ELSE** [return this value]

The signature of the IF Function:

=IF(logical_test, [value_if_true], [value_if_false])

The first input is **logical test**. This is where your expression is evaluated.

**Logical Test Examples:** *A > B*…

Leverage the lesser known features of SUM and COUNT

Both SUM and COUNT *ignore**empty cells* and *cells that contain text*.

=SUM() returns the sum of numerical values in a range

=COUNT() returns a count of numerical values in a range

A ground up explanation

A Function does two things:

- Receives an input (sometimes multiple inputs)
- Returns a value as an output

**=FUNCTION_NAME**(*input_a, [input_b], …*)

**“=”**is at the beginning of every function in Microsoft Excel**“FUNCTION_NAME”**is the name of the function- “(“ opening parenthesis identifies the start of the…

Save time and avoid re-work with the clever use of simple formulas in Microsoft Excel.

Formulas can be as simple as a cell reference. Microsoft has a good intro video here

** Sales Manager:** Are there any canceled customers on our

** Clever Data Person:** Hmm. I’m not sure, but I can find out. What are we using this for?

** Sales Manager:** We want to reach out to customers who have canceled and understand more about why our service…

Do you have time to clean up this email list?

**As clever data people, our answer is “yup, for sure.”**

Work involving data is rarely as simple as the question makes it seem.

Let’s find out by asking the Sales Manager a couple of quick questions.

**…**