• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

Excel SumIf Function

The SUMIF function totals the values of a range that meet specific criteria. For example it will total only the orders from a specific company or after a specific date.

The syntax for SUMIF is:

=SUMIF(range, criteria, [sum_range])

ArgumentPurpose
RangeThe range of cells to evaluate.
CriteriaThe condition that defines which cells are to be added.
Sum rangeThe actual cells to sum. If omitted the values in range are added.

The example below demonstrates SUMIF being used to sum the total sales of wardrobes.

Excel SUMIF function

Primary Sidebar

Recent Posts

  • LIVE Currency Exchange Rate in Excel
  • N Function in Excel
  • Non-Adjacent Columns with FILTER Function
  • Moving Average in Excel
  • Excel IMAGE Function – Insert Images from a Cell Value
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·