conditionally summarize data using a formula

Microsoft Excel 2007 Objective 3: Creating and Modifying Formulas

Upload: coachhahn

Post on 25-Jan-2015

403 views

Category:

Technology

0 download

Report

Download

Embed Size (px):

DESCRIPTION

TRANSCRIPT

Page 1: Conditionally summarize data using a formula

Microsoft Excel 2007Objective 3: Creating and Modifying Formulas

Page 2: Conditionally summarize data using a formula

In the Lesson you will learn how to:1. Reference data in formulas2. Summarize data using formulas3. Summarize data using subtotals4. Conditionally summarize data using a

formula5. Lookup data using a formula6. Use conditional logic in a formula7. Format or modify text using formulas, and8. Display and print formulas

Page 3: Conditionally summarize data using a formula

Conditionally Summarize Data Using a Formula• Summarize data that meets certain conditions

Page 4: Conditionally summarize data using a formula

Summarize Data That Meets Certain Conditions1. Verify the worksheet has a range to

search and numerical values to summarize

2. Click in a cell that will contain the conditional formula result

3. Type =, then type a conditional function using the slide following as a reference

Page 5: Conditionally summarize data using a formula

Functions to Summarize Data Based on ConditionsConditional Function

Video Intro Explanation and Practice

SUMIF Video Practice

SUMIFS Practice

COUNTIF Video Practice

COUNTIFS Practice

AVERAGEIF Video Practice

AVERAGEIFS Practice

http://office.microsoft.com/en-us/excel-help/results.aspx?filter=1&ck=1&qu=SUMIF&ex=2

http://office.microsoft.com/en-us/excel-help/sumif-function-HP010342932.aspx?CTT=1%23_Example

http://office.microsoft.com/en-us/excel-help/sumifs-function-HA010342933.aspx?CTT=1

http://office.microsoft.com/en-us/excel-help/video-countif-function-VA102534075.aspx?CTT=1

http://office.microsoft.com/en-us/excel-help/countif-function-HP010342346.aspx?CTT=1

http://office.microsoft.com/en-us/excel-help/countifs-function-HA010342347.aspx?CTT=1

http://office.microsoft.com/client/helppreview.aspx?AssetId=HA100474339990&lcid=1033&NS=EXCEL&Version=12&pid=CH010064538&CTT=4

http://office.microsoft.com/client/helppreview.aspx?AssetId=HA100474939990&lcid=1033&NS=EXCEL&Version=12&pid=CH010064538&CTT=4

The Lived Experiences of Conditionally Admitted College Students

Conditionally speaking

Guideline for Conditionally Registered Vehicles in …/media/...for_conditionally_registered_vehicles... · o This guideline replaces the Guideline for Conditionally Registered Vehicles

Conditionally Convergent Spectral Sequences€¦ · Conditionally Convergent Spectral Sequences by J. Michael Boardman March 1999 Abstract Convergence criteria for spectral sequences

Genome Scanning for Conditionally Essential Genes in ...aem.asm.org/content/78/9/3098.full.pdfGenome Scanning for Conditionally Essential Genes in Salmonella enterica Serotype Typhimurium

CONDITIONALLY ADAPTIVE MULTI-TASK LEARNING I T …

Conditionally Exempt Small Quantity Generator Handbook for hazardous Waste … · This handbook is intended as an educational tool for Conditionally Exempt Small Quantity Generators

MINING SCHEDULE OPTIMISATION FOR CONDITIONALLY

CondConv: Conditionally Parameterized Convolutions for ... · CondConv: Conditionally Parameterized Convolutions for Efﬁcient Inference Brandon Yang Google Brain [email protected]

Conditionally Evenly Convex Sets and Evenly Quasi … regulating agencies asked for computational methods to estimate the capital ... the more complex structure of ... Conditionally

Governor Christie Conditionally Vetoes S2756

Essential and Conditionally-Essential Nutrients in ...€¦ · ESSENTIAL AND CONDITIONALLY-ESSENTIAL NUTRIENTS IN CLINICAL NUTRITION GEORGE K. GRIMBLE Department of Gastroenterology

Is IFRS conditionally or unconditionally more conservative ... ANNUAL... · Is IFRS conditionally or unconditionally more conservative than local GAAP? Evidence from Japan Abstract

Guideline for Conditionally Registered Vehicles in

Governor Christie Conditionally Vetoes S1813

Governor Christie Conditionally Vetoes S2065

Governor Christie Conditionally Vetoes S1643

WHITEPAPER / MARINE & PORTS B0 a conditionally …...WHITEPAPER / MARINE & PORTS B0 a conditionally and periodically unmanned bridge Captain Eero Lehtovaara, AFNI Dr. Kalevi Tervo

Scheduling bods jobs sequentially and conditionally

PR89-046 Conditionally approved

Conditionally Activated Antibody Therapeutics

Governor Christie Conditionally Vetoes A2768

Biosecurity (Prohibited and Conditionally Non-prohibited

List of Unconditionally/Conditionally Approved Candidates

Essential summarizer: Search to Summarize, News to Summarize and Tweet to Summarize search13

B-3.1: Summarize photosynthesis & interpret the formula

Factors Influencing Success of Conditionally …182 • The CATESOL Journal 23.1 • 2011/2012 Factors Influencing Success of Conditionally Admitted Students in Graduate TESOL Programs

Governor Christie Conditionally Vetoes A1705

Conditionally Exempt Small Quantity Generator Handbook for

Conditionally Active Antibody Therapeutics

The panel conditionally homogenous vectorautoregressive model

Phys.2212 practicing problems Review the tests, quizzes. Practice ‘stop to think’ Chapt. 30, 32, 33, 34 Summarize the homework. prepare your own formula

§4-71-6.5 LIST OF CONDITIONALLY APPROVED ANIMALS

Conditionally Guaranteed Budgets for High-Quality Video ... · TU/e Informatica, System Architecture and Networking 1 Conditionally Guaranteed Budgets for High-Quality Video Processing

Approximate Bayesian Inference in Conditionally ... · Approximate Bayesian Inference in Conditionally Independent Hierarchical Models (Parametric Empirical Bayes Models) Author(s):