Logical Functions in Excel (IF, IFS, AND, OR, COUNTIF, SUMIF)
In this Excel tutorial, we take a look at Logical Functions in Excel. That’s functions such as IF, IFS, COUNTIF and SUMIF. This is an Excel tutorial for beginners or those who need to brush up on their Excel. This was taken from a live, recorded session. You can download the Excel files that Debs uses below the video and follow along.
Once again this was a brilliant live session. Logical functions in Excel are incredibly useful and once you get your head around them, simple to use. In this session we covered:
- The IF Function
- Nested IF in Excel
- The IFS Function
- The AND and OR Functions
- COUNTIF and SUMIF
- Error checking Functions IFERROR and IFNA
To learn all about the more advanced versions of some of these functions, take a look at these tutorials on COUNTIFS, and SUMIFS.
Other Excel classes you might like:
- Introduction to Power Pivot & Power Query in Excel
- What-If Analysis in Excel
- Designing Better Spreadsheets in Excel
Take a look at more recorded live classes from Simon Sez IT.
Adam Lacey
Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats. When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.