Chapter.02 CGS2518

Office excel 2010 level 2 home 34 examples of sumif

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: oft Office Excel 2010 Level 2 home 29 Types of Criteria Specified for the COUNTIF Func/on Succeeding in Business with Microsoft Office Excel 2010 Level 2 home 30 Rela/onal Operators Succeeding in Business with Microsoft Office Excel 2010 Level 2 home 31 Wildcards Succeeding in Business with Microsoft Office Excel 2010 Level 2 home 32 Sample Result of COUNTIF Func/on Succeeding in Business with Microsoft Office Excel 2010 Level 2 home 33 Determining a Total Value for Items that Meet Specified Criteria •  Use SUMIF func3on to add all values in a range that meet specified criteria –  =SUMIF (range,criteria,sum_range) –  Sum_range argument iden3fies corresponding cell range to sum if specified criteria have been met in the range established by the “range” argument Succeeding in Business with Microsoft Office Excel 2010 Level 2 home 34 Examples of SUMIF Func/on Succeeding in Business with Microsoft Office Excel 2010 Level 2 home 35 Level 2 Summary •  Tail values – highest and lowest five elements of each data set – and their rela3ve rankings •  Summarizing analyses by coun3ng the number of items that meet specific criteria and summing items that meet specific criteria •  Including rela3onal operators and wildcards in func3ons and formulas Succeeding in Business with Microsoft Office Excel 2010 36 Level 3 Objec/ves: Extending the Analysis with What ­If, Goal Seek, and Simula/on Evaluate a large data set Apply custom number formats to data Perform what ­if analyses Perform reverse what ­if analyses using Goal Seek •  Analyze data by category by combining func3ons •  Simulate data to evaluate different outcomes •  •  •  •  Succeeding in Business with Microsoft Office Excel 2010 37 Evalua/ng a Larger Data Set •  Separately list inputs, especially those likely to change or that you might want to explore with “what ­if” scenarios •  If a large number of data inputs, place them on a separate worksheet or in a separate area on the same worksheet Succeeding in Business with Microsoft Office Excel 2010 Level 3 home 38 Specifying a Custom Number Format •  Use to alter format of a cell without altering the value •  Format codes ...
View Full Document

This note was uploaded on 05/24/2012 for the course CGS 2518 taught by Professor Gower-winter during the Spring '12 term at FSU.

Ask a homework question - tutors are online