Manager new perspectives on microsoft excel 2010 43

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Using the Conditional FormattingP XP X Rules Manager New Perspectives on Microsoft Excel 2010 43 XP XP Summarizing Data CUse COUNTIF, SUMIF, and AVERAGEIF onditionally • functions to calculate a conditional count, sum, or average using only cells that meet a particular condition New Perspectives on Microsoft Excel 2010 44 XP Using the COUNTIF Function XP • • • Calculates the number of cells in a range that match specified criteria Sometimes referred to as a conditional count Syntax: New Perspectives on Microsoft Excel 2010 45 XP Using the COUNTIF Function XP New Perspectives on Microsoft Excel 2010 46 Using the SUMIF Function • • • XP XP Adds values in a range that meet your criteria Also called a conditional sum Syntax: New Perspectives on Microsoft Excel 2010 47 Using the AVERAGEIF Function Similar to SUMIF function XP XP • • • Calculates the average of values in a range that meet criteria you specify Syntax: New Perspectives on Microsoft Excel 2010 48 Using the AVERAGEIF Function New Perspectives on Microsoft Excel 2010 XP XP 49...
View Full Document

This document was uploaded on 02/24/2014.

Ask a homework question - tutors are online