Excel Tutorial
Excel tutorials, quizzes & AI guides — all levels
RSS
  • Online Excel Exercises
  • Training
  • Excel Tests
  • Sitemap
  • Premium Quizzes
  • Shop
  • My account

SUMIFS

SUMIFS helps you add up numbers in Excel based on multiple conditions. It works like SUMIF but allows you to set more than one rule. This function is useful for analyzing data, such as summing sales for a specific product in a chosen month.

SUMIF vs SUMIFS Which Formula to Choose

SUMIF vs SUMIFS in Excel: The Trap of the Argument Order

SUMIF puts the column to add last, SUMIFS puts it first. Why the order changed in Excel 2007, the silent 0 it causes, and a free exercise.
SUMIFS function cover

SUMIFS Function in Excel

Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets

Categories

  • AI & Excel (3)
  • Conditional (13)
  • Conditional Formatting (18)
  • Date (48)
  • Dynamic Arrays (10)
  • Excel Charts (12)
  • Excel Online (4)
  • Excel Tests (8)
  • Excel Training (13)
  • Excel Tutorial (16)
  • Expert (26)
  • Finance (7)
  • Free Excel Tutorial for beginners (29)
  • Function (1)
  • Intermediate Excel Skills: Tutorials and Articles (19)
  • Lookup functions (14)
  • Manage data (18)
  • Maps and GPS (5)
  • Pivot Table (10)
  • Power Query (6)
  • Quiz Premium (7)
  • Shortcuts (5)
  • Statistical functions (27)
  • Text functions (21)
  • Tips and Tricks (22)

SUMIFS

SUMIF vs SUMIFS in Excel: The Trap of the Argument Order

SUMIF vs SUMIFS Which Formula to Choose

SUMIFS Function in Excel

SUMIFS function cover

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net