'

7

Понравилась презентация – покажи это...





Слайд 0

Ways to Count in Excel 7 Function Tips and Tricks


Слайд 1

1 Problem # How many cells contain numbers? Count Numbers


Слайд 2

1 Function # Only counts numbers Text and blank cells are ignored NOTE: Dates are numbers, so they would be counted too COUNT


Слайд 3

2 Problem # How many cells contain any type of data? Count All Data


Слайд 4

2 Function # COUNTA Counts numbers, text, TRUE/FALSE Blank cells are ignored NOTE: Cells that look blank might be counted, if they contain an empty string – ""


Слайд 5

3 Problem # How many cells are empty? Count Empty Cells


Слайд 6

3 Function # COUNTBLANK Counts cells that are empty Cells with data are ignored NOTE: Cells that look blank might not be counted, if they contain an empty string – ""


Слайд 7

4 Problem # How many orders for “Pen”? Count Specific Items


Слайд 8

4 Function # COUNTIF Counts cells that contain exact data NOTE: Criteria can be typed in the formula, or use reference to another cell


Слайд 9

5 Problem # How many item names contain “Pen”? Count Partial Items


Слайд 10

5 Function # COUNTIF & * Wildcard “*” used with criteria “*” represents any characters NOTE: Criteria can be typed in the formula, or use reference to another cell


Слайд 11

6 Problem # How many Pen orders for 10 or more? Multiple Criteria


Слайд 12

6 Function # COUNTIFS Count based on multiple criteria NOTE: Criteria can be typed in the formula, or use reference to another cell


Слайд 13

7 Problem # How many numbers in filtered list? Filtered List


Слайд 14

7 Function # SUBTOTAL SUBTOTAL(102, Only counts numbers in visible rows NOTE: Option 2 ignores rows hidden by filter; Option 102 also ignores manually hidden rows


Слайд 15

More Excel Functions Count Functions (get the sample file for this slide show) Sum Functions  VLOOKUP Function  INDEX / MATCH Functions INDIRECT Function 


Слайд 16

Excel Tips & Tutorials http://www.contextures.com/ 30excelfunctionsin30days01.html Visit Contextures.com 30 Excel Functions Kit


×

HTML:





Ссылка: