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

SUMIF

SUMIF is a function in Excel that adds numbers when a certain condition is met. Use it to simplify your calculations, keep your data organized, and save time on repetitive tasks. This resource shows you how to create formulas, choose the right criteria, and troubleshoot common errors, so you can work faster and more accurately in your spreadsheets.

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.
GROUPY function cover

GROUPBY vs SUMIF in Excel

Discover how the GROUPBY function simplifies Excel data analysis by replacing complex COUNTIF and SUMIF formulas effortlessly.
Typing on a computer

Solve SUMIF Exercise: Answer Fun Questions

Level up your Excel skills with this SUMIF exercise. From basic questions to advanced logic, learn how to calculate totals like a pro.
SUMIF function cover

How to Use the SUMIF Function in Excel

Learn how to correctly set the SUMIF function in Excel and avoid mistakes. Analyze data efficiently with this powerful function.
GROUPY function cover

GROUPBY function: The future of COUNTIF SUMIF

Find out how to build and use the GROUPBY function in Excel 365. Group data, calculate summaries, and update instantly.
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)

SUMIF

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

SUMIF vs SUMIFS Which Formula to Choose

GROUPBY vs SUMIF in Excel

GROUPY function cover

Solve SUMIF Exercise: Answer Fun Questions

Typing on a computer

How to Use the SUMIF Function in Excel

SUMIF function cover

GROUPBY function: The future of COUNTIF SUMIF

GROUPY function cover

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