Posts Tagged ‘COUNTIF’
June 28th, 2010
See how to create a dynamic frequency table and histogram chart using Defined Name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic. This dynamic chart and table will update anytime that new data is added to column A.
Tags:
March 10th, 2010
See how to create a dynamic array formula quickly using the Drill Through Method so that the sub table will automatically be populated with any new data added to the Master Sheet. See the functions: COUNTIF, IF, ROWS, INDEX, SMALL, ROW. See how to create a 3 dimensional table set up like in a database program. Extract Records Formula
February 23rd, 2010
Methods: 1) Excel 2007 built-in method, 2) COUNTIF functions, 3) COUNTIF function for whole row See how to In Excel 2007 / 2010 use Conditional Formatting: 1) Highlight cells with seat names 2) On the Home ribbon, go to the Styles group, then to Conditional Formatting, then to Highlight Cells Rules, Then to Duplicate Values In Excel 2003 and earlier use Conditional Formatting 1) Format menu, Conditional Format 2) Select Is Formula from first textbox 3) Enter formula: =COUNTIF($A:$A,A1) Greater than 1 (this is simple example where names are in range A1:A8. 4) add formatting
January 16th, 2010
See methods for counting: specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values than are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, not words, and more! Learn about the syntax that the COUNTIF function uses and see different methods to achieve the same goal. See COUNTIF, COUNTBLANKS, COUNTA, COUNT functions
December 18th, 2009
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.