Criteria Articles

Articles tagged Criteria, including related tutorials, examples, and walkthroughs.

2 articles

2025-05-15

How to Use XLOOKUP with Multiple Criteria in Excel

Learn how to use XLOOKUP with multiple criteria in Excel by combining Boolean logic or concatenation for cleaner, more flexible lookups....

#criteria#lookup#formulas

SUMIF and SUMIFS in Excel: Syntax, Examples, and Differences

Learn when to use SUMIF or SUMIFS in Excel, with working text, wildcard, and date examples—and see how their argument order differs....

#criteria#formulas#functions#math

8 min read

Read Article

About Excel Semi Pro

Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.