Excel 365 The IF Functions: Easy Excel 365 Essentials, #5

By M.L. Humphrey

The IF functions are some of the most powerful functions in Microsoft Excel. With IF, IFS, COUNTIFS, SUMIFS, AVERAGEIFS, MINIFS, and MAXIFS you can perform almost any conditional calculation you want.

 

Note that many of the functions covered in this book are functions that were not available in earlier versions of Microsoft Excel, so if you're using a version of Excel prior to Excel 2019, you may want to buy the original IF Functions title that is part of the original Easy Excel Essentials series instead.

* * *

This book is part of the Easy Excel 365 Essentials series of titles. These are targeted titles that are excerpted from the main Excel 365 Essentials series and are focused on one specific topic.

 

If you want a more general introduction to Excel, then you should check out the Excel 365 Essentials titles instead. In this case, 102 Useful Excel 365 Functions which covers many more functions.

• Language: English
• Publisher: M.L. Humphrey
• Release date: Jan 3, 2023
• ISBN: 9798215585139

M.L. Humphrey

Hi there Sci Fi fans, my name is Maurice Humphrey.I am a Vermont native, husband, father, grandfather, well over 60, Navy veteran, retired IBM engineer, retired printer repairman, Graduated: Goddard Jr. College, VT Technical College, and Trinity College. Over the years I’ve written technical articles, taught technical classes, and presented at technical conventions.I’ve been reading science fiction for over 50 years now. First books were “Journey to the Centre of the Earth” by Jules Verne and “The Stars Are Ours” by Andre Norton. I’ve read and collected many great stories, and a considerable amount of junk ones as well. I’d say by now that I probably have a good idea of what I consider a good story.

Book preview

Excel 365 The IF Functions

ALSO BY M.L. HUMPHREY

Listing of all books by M.L. Humphrey

Excel 365 Essentials

Excel 365 for Beginners

Intermediate Excel 365

102 Useful Excel 365 Functions

Easy Excel 365 Essentials

Formatting

Conditional Formatting

Charts

Pivot Tables

The IF Functions

LOOKUP Functions

EXCEL 365 THE IF FUNCTIONS

EASY EXCEL 365 ESSENTIALS - BOOK 5

M.L. HUMPHREY

CONTENTS

Introduction

The COUNTIFS, SUMIFS, AVERAGEIFS, MINIFS, and MAXIFS Functions

The IF and IFS Functions

Appendix: Basic Terminology Recap

About the Author

Copyright

INTRODUCTION

This book is part of the Easy Excel 365 Essentials series of titles. These are targeted titles that are excerpted from the main Excel 365 Essentials series and are focused on one specific topic.

If you want a more general introduction to Excel, then you should check out the Excel 365 Essentials titles instead. In this case, 102 Useful Excel 365 Functions which covers the various IF functions as well as a number of other functions.

But if all you want is a book that covers this specific topic, then let’s continue with a discussion of how to use IF, IFS, COUNTIFS, SUMIFS, AVERAGEIFS, MINIFS, and MAXIFS.

(And, by extension, COUNTIF, SUMIF, and AVERAGEIF.)

THE COUNTIFS, SUMIFS, AVERAGEIFS, MINIFS, AND MAXIFS FUNCTIONS

Notation:

COUNTIFS(criteria_range1, criteria1, …)

SUMIFS(sum_range, criteria_range1, criteria1, …)

AVERAGEIFS(average_range, criteria_range1, criteria1, …)

MINIFS(min_range, criteria_range1, criteria1, …)

MAXIFS(max_range, criteria_range1, criteria1, …)

Excel Definition:

COUNTIFS: Counts the number of cells specified by a given set of conditions or criteria.

SUMIFS: Adds the cells specified by a given set of conditions or criteria.

AVERAGEIFS: Finds average (arithmetic mean) for the cells specified by a given set of conditions or criteria.

MINIFS: Returns the minimum value among cells specified by a given set of conditions or criteria.

MAXIFS: Returns the maximum value among cells specified by a given set of conditions or criteria.