Pinterest Pixel

SUMIF Function: Introduction

  What does it do? Sums the values in a range that meet a criteria that you... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

 

What does it do?

Sums the values in a range that meet a criteria that you specify

Formula breakdown:

=SUMIF(Range or Cells, Criteria, [Sum_Range])

What it means:

=SUMIF(Evaluate this Range/Cells, With this Criteria, [Optional Sum Range])


The SUMIF function is used widely amongst spreadsheet users as it is a simple Excel function.  It allows you to Sum the values in a range that meet a criteria that you specify.

So if you want to Sum a range of sales values that are above $3,000 then this is the best Excel function to use, as I explain below.

SUMIF Function: Introduction | MyExcelOnline

Download excel workbookSumIf.xlsx

We want to get the sum of the sales amounts that are above $3000.

STEP 1: We need to enter the SUMIF function in a blank cell:

=SUMIF(

SUMIF Function: Introduction

 

STEP 2: The SUMIF arguments:

Range

What is your range that contains the source data?

See also  Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways

Highlight the column that contains the sales data

=SUMIF(D15:D23,

SUMIF Function: Introduction

Criteria

Which records do you want to sum together?

Since we want to sum the amounts greater than 3000, then let’s type in >3000

=SUMIF(D15:D23, “>3000”)

SUMIF Function: Introduction

Just like that, Excel has selectively found the values and summed them together!

SUMIF Function: Introduction

How to Use the Sumif Formula in Excel

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!