Learn Excel 2010 – “Count Between A Range”: Podcast #1508
January 19, 2012 at 2:27 pm MrExcel East
The Question: “I have a =COUNTIF to count values less than 10 and another to count values less than 20; but how do I count the values that fall between 10 and 20?” In Excel 2007 and newer, there is a New Function called ‘=COUNTIFS”. Follow along with Bill in Episode #1508 to learn how to solve this question – even if you are using Excel 2003 or earlier!
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Entry filed under: Learn Excel 97-2007, Excel 2010, MrExcel Products, Excel 2007, Learn Excel from MrExcel, New MrExcel Publication, MrExcel Podcast, Excel 2003, Learn Excel 2007 through Excel 2010. Tags: MrExcel, technology, Excel, tutorial, spreadsheets, business, formulas, SUMPRODUCT, COUNTIF, Excel 2007, Worksheet, 2010, 2007, Functions, Bill Jelen, Excel 2010, 2003, Excel 2003, Greater Than, Less Than, Count between Range.
Trackback this post