Excel Tip Tuesday: More IF Functions

Posted by Lisa on October 23, 2018 at 10:30 AM

Excel IconAfter reading last week's blog post on the IF formula, perhaps you started browsing through other Logical Functions using the fx button in the formula bar. If so, you might have noticed that there are several different IF functions. These are useful, say, for IF you want to add together a list of values based on a specific criteria. Or what IF you want to count data based on a specific criteria or even find the average? Here are some examples of what you can do with the SUMIF, COUNTIF, and AVERAGEIF functions in Excel. In the first two columns I show samples, the next column is a description of the formula, then a view of the formula, and, finally, the formula results in the last column.

Excel Tip Tuesday: More IF Functions

Leave us a comment and let readers know what Excel tips you use on a daily basis.

Topics: Excel

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

    Recent Posts