Pinterest Pixel

SUMIF Function: Introduction

John Michaloudis
What does it do? .

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.

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?

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

 

 

If you like this Excel tip, please share it


Founder & Chief Inspirational Officer

at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Evaluate Formulas Step By Step in Excel

Steps To Follow

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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!

Share to...