Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Ram asks how to split a word into individual letters, and then count how many times each letter appears. Episode 1148 shows you how.
Labels: COUNTIF, MID, SUMPRODUCT
posted by Bill at 9:00 AM
BackIn2Shape at YouTube has two worksheets; one of customers, and one of prospects. If a prospect is on the customer list, he would like to delete it. Episode 1109 show you how.
posted by Bill at 9:00 AM
DRG asks how to use COUNTIF to find records that match a range. Unfortunately, it can not be done with COUNTIF. In Episode 1100, Bill and Mike compare six solutions.
posted by Bill at 9:00 AM
How to use COUNTIF to count survey answers for a subset of rows. Bill and Mike show many methods in Episode 1065.
Labels: COUNTIF, COUNTIFS, formula, Pivot Table
posted by Bill at 9:00 AM
Andy wonders why the COUNT function doesn't count text entries. Episode 955 will show you how to overcome this with COUNTA.
posted by Bill at 9:00 AM
Loh from Malaysia sends in a very hard question. How can you use COUNTIF to analyze only the visible rows from a filtered data set? I knew the solution would have to involve iterating through multiple SUBTOTAL functions, but Aladin from the MrExcel Message board provides the solution. Episode 946 shows you how.
posted by Bill at 9:00 AM
Ben asks how he can automatically append a sequence number to duplicate values in his spreadsheet. Episode 537 shows how.
Labels: COUNTIF
posted by Bill at 9:00 AM
Kyle is trying to build a worksheet to create practice SAT tests for his students. His IF formula to mark answers as correct is working fine, but the COUNT function can’t seem to count the correct answers. Episode 534 troubleshoots this function.
posted by Bill at 9:00 AM
Ricardo sends in a tricky formula question for today’s podcast. How can you calculate a moving average of all sales in the last 90 days, particularly when your data does not include one row for every day? In Episode 512, I discuss the really convoluted solution in Excel 2003 and the only slightly convoluted solution in Excel 2007.
Labels: COUNTIF, formula, moving average, SUMIF
posted by Bill at 9:00 AM
Thanks to many viewers who wrote in after Episode 497, there is a much easier way to count the number of cells that contain a certain substring. In Episode 505, learn how to use the wildcard options in COUNTIF and AutoFilter.
Labels: COUNTIF
posted by Bill at 9:00 AM
George sends in a question – How can COUNTIF be made to look for cells that match a pattern? Episode 497 shows the long workaround to this problem.
Labels: COUNTIF
posted by Bill at 9:00 AM
