Magic Tricks Videos

E1.12 COUNTIF in Microsoft Excel E1.12 COUNTIF in Microsoft Excel
Posted by: Firchild

Video duration: 118 seconds
Global video hits: 2537

Using COUNTIF function to count the number of A's, B's and C's (can be adapted)

Related: excel, spreadsheet, countif, metadata

Display Video Comments | Hide Video Comments | Add Comment

SUM SUMIF COUNT COUNTIF - Excel for Business - Lesson 3 SUM SUMIF COUNT COUNTIF - Excel for Business - Lesson 3
Posted by: raycolondotcom

Video duration: 346 seconds
Global video hits: 11965

New Web Site: www.Excel4BusinessOn line.com Excel tutorial on the uses of the math functions SUM, SUMIF, COUNT, and COUNTIF. MARCH 2009 UPDATE: New Excel tutorials have been posted to my other YouTube channel, Excel4Business. These new videos are posted in HD format.

Related: excel, business, math, functions, sum, sumif, count, countif, computer, science, spreadsheets

Display Video Comments | Hide Video Comments | Add Comment

YTLE#54: Excel Advanced Filter and COUNTIF function YTLE#54: Excel Advanced Filter and COUNTIF function
Posted by: ExcelIsFun

Video duration: 189 seconds
Global video hits: 4161

See how to use Advanced Filter Unique Records Only and the COUNTIF function to count unique records that are greater than $30. Remove Duplicates Duplicate.

Related: excel, advanced, filter, unique, records, only, countif, function, greater, than, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions
Posted by: ExcelIsFun

Video duration: 447 seconds
Global video hits: 7576

See how to create Quantitative Data Stem & Leaf Chart using the REPT and COUNTIF functions. This is a BIG formula...Chapter 02 Busn 210 Business and Economic Statistics and Excel Class This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel ExcelIsFun Girvin

Related: excel, 2007, statistics, see, how, to, create, quantitative, data, stem, leaf, chart, using, the, rept, and, countif, functions

Display Video Comments | Hide Video Comments | Add Comment

Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax
Posted by: ExcelIsFun

Video duration: 501 seconds
Global video hits: 995

Learn that comparative operators for COUNTIF and SUMIFS functions must be text and have double quotes , but logical formulas (TRUE FALSE) do not require double quotes and are not considered text.

Related: excel, 2007, 2010, countif, sumifs, functions, logical, formulas, have, different, syntax, excelisfun, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

YouTubersLoveExcel#41: Prevent Duplicates COUNTIF Data Valid YouTubersLoveExcel#41: Prevent Duplicates COUNTIF Data Valid
Posted by: ExcelIsFun

Video duration: 189 seconds
Global video hits: 2003

See how to use a True/False formula with the COUNTIF function and Data Validation to Prevent Duplicate entries.

Related: excel, prevent, duplicates, countif, function, true, false, formula, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Dueling: CountIf 3 Criteria - 1065 - Learn Excel Podcast Dueling: CountIf 3 Criteria - 1065 - Learn Excel Podcast
Posted by: bjele123

Video duration: 635 seconds
Global video hits: 291

How to use COUNTIF to count survey answers for a subset of rows. Bill and Mike show many methods in Episode 1065. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Related: excel, business, accounting, spreadsheets, tutorial, technology, mrexcel, countifs, pivot, table, formula, countif

Display Video Comments | Hide Video Comments | Add Comment

\ 'countif' and 'sumif' functions
Posted by: dineshtakyar

Video duration: 83 seconds
Global video hits: 1234

'count' and 'sum' functions are widely used but 'countif' and 'sumif' can solve more problems in Excel, especially, when you need to do criteria based calculations.

Related: microsoft, excel, countif, sumif, functions

Display Video Comments | Hide Video Comments | Add Comment

Excel Magic Trick # 269: COUNTIF & Ampersand Excel Magic Trick # 269: COUNTIF & Ampersand
Posted by: ExcelIsFun

Video duration: 170 seconds
Global video hits: 1314

See how to get criteria from four (4) different cells and combine (join) them into one criterion for the COUNTIF function. See how to use the COUNTIF function and the Ampersand to count the number of items that match from a sample. Count with criteria condition.

Related: excel, countif, function, formula, ampersand, join, criteria, criterion, count, with, condition, excelisfun, mike, gel, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

YouTubers Love Excel 12: Pivot Table AVERAGEIF SUMIF/COUNTIF YouTubers Love Excel 12: Pivot Table AVERAGEIF SUMIF/COUNTIF
Posted by: ExcelIsFun

Video duration: 497 seconds
Global video hits: 8594

See how to average with criteria using a Pivot Table (PivotTable), the AVERAGEIF function and the SUMIF/COUNTIF functions! Also see how to create many formulas all at once by using the correct type of cell references. Pivot Table (PivotTable) for averaging with multiple criteria AVERAGEIF function for averaging with multiple criteria SUMIF/COUNTIF functions for averaging with multiple criteria

Related: excel, pivot, table, pivottable, averageif, function, sumif, countif, functions, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions
Posted by: ExcelIsFun

Video duration: 288 seconds
Global video hits: 17269

See how to use the SUMIF and COUNTIF functions to add and count given a certain condition. With this trick you can add only the sales for the salesperson Tina -- or count them! Also, see the super fast keyboard shortcut for naming multiple ranges. Count words text based on a Condition. Count words text based on criteria. SUM Values based on a Condition. SUM Values based on criteria.

Related: microsoft, excel, spreadsheets, sumif, countif, sum, add, count, conditionally, given, criteria, mike, gel, girvin, highline, community

Display Video Comments | Hide Video Comments | Add Comment

YTLE#53: Excel Pivot Table and COUNTIF function YTLE#53: Excel Pivot Table and COUNTIF function
Posted by: ExcelIsFun

Video duration: 206 seconds
Global video hits: 3672

See how to use a Pivot Table (PivotTable) and the COUNTIF function to count unique records that are greater than $30. Remove Duplicates Duplicate.

Related: excel, count, unique, records, more, than, 30, countif, function, pivot, table, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

The COUNTIF Function in MS Excel The COUNTIF Function in MS Excel
Posted by: InfoCenterLive

Video duration: 297 seconds
Global video hits: 9187

Shows you how to use the COUNTIF function in Microsoft Excel

Related: excel, countif, microsoft

Display Video Comments | Hide Video Comments | Add Comment

Excel 2007 - The COUNTIF function and absolute references Excel 2007 - The COUNTIF function and absolute references
Posted by: ictteachercom

Video duration: 508 seconds
Global video hits: 5369

Excel 2007 - The COUNTIF function and absolute cell references

Related: excel, 2007, formula, function, countif, absolute, cell, reference, count, tutorial, ictteacher

Display Video Comments | Hide Video Comments | Add Comment

Excel i-Teach-u 13 Sumif, Rank & Countif Excel i-Teach-u 13 Sumif, Rank & Countif
Posted by: JackBarnett21

Video duration: 365 seconds
Global video hits: 2879

This video looks at the use of Sumif, Rank and Countif. You can see how each of these is used and you should attempt to replicate this. Dedicated to the late John Hooton, Great Tutor at the University of Westminster, who gave me a love of Excel.

Related: excel, i-teach-u, 13, sumif, rank, countif, john, hooton, university, of, westminster

Display Video Comments | Hide Video Comments | Add Comment

YTLE#55: Excel 2007 Remove Duplicates and COUNTIF function YTLE#55: Excel 2007 Remove Duplicates and COUNTIF function
Posted by: ExcelIsFun

Video duration: 150 seconds
Global video hits: 3072

See how to use Excel 2007 Remove Duplicates and the COUNTIF function to count unique records that are greater than $30.

Related: excel, 2007, remove, duplicates, and, the, countif, function, greater, than, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

SUMIF and COUNTIF functions in Excel SUMIF and COUNTIF functions in Excel
Posted by: AuditExcel

Video duration: 247 seconds
Global video hits: 7047

How to use the SUMIF and COUNTIF functions in Excel - TO RECEIVE AUDIO PLEASE SEARCH FOR SUMIF AND COUNTIF FUNCTIONS IN EXCEL V2

Related: microsoft, excel, training, videos

Display Video Comments | Hide Video Comments | Add Comment

Excel Magic Trick # 266: Count Words Only w COUNTIF ?* Excel Magic Trick # 266: Count Words Only w COUNTIF ?*
Posted by: ExcelIsFun

Video duration: 254 seconds
Global video hits: 1326

See that COUNT and COUNTA have trouble counting only words or text. Learn how the simple function COUNTIF with the wildcards? and * will solve this problem. Also see: Excel Magic Trick #77: COUNT Vs. COUNTA function Aladin at the Mr Excel Message Board mrexcel

Related: excel, count, counta, countif, function, formula, words, text, only, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Excel Tutorial - COUNTIF function Excel Tutorial - COUNTIF function
Posted by: supernicko79

Video duration: 411 seconds
Global video hits: 1049

Ever needed to count the number of "Yes" in a list? What about the number of cells which a number greater than 42? Why not try COUNTIF? I'll walk you through it.

Related: excel 2007, excel, excel 2003, tutorial, countif

Display Video Comments | Hide Video Comments | Add Comment

AM 4213 Statistical functions Countif Countblank Rank Microsoft Excel 2003 ECDL Advanced ITQ 3 AM 4213 Statistical functions Countif Countblank Rank Microsoft Excel 2003 ECDL Advanced ITQ 3
Posted by: ronzohaylau

Video duration: 583 seconds
Global video hits: 370

AM 4213 Statistical functions Countif Countblank Rank Microsoft Excel 2003 ECDL Advanced ITQ 3

Related: am, 4213, statistical, functions, countif, countblank, rank, microsoft, excel, 2003, ecdl, advanced, itq

Display Video Comments | Hide Video Comments | Add Comment

Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33


Search for a video theme of your choice.

 

  Targeted Videos

  Related Links

You like it? Share it!



Magic Tricks videos :: Social Bookmarking Social Bookmarking :: Videos are copyright their respective owners.