Looking back to August 2011, a ‘Learn Excel from MrExcel‘ Podcasts looked at how to Sum Colored Cells; Episode #1415 showed us how we could be obtaining the ‘Sum’ of the Red Rows. Today, in Episode #1687, Bill revisits that earlier Podcast to show us how to Count the Number of Rows containing Red Cells, not Sum the Cell Values.


“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!

and for more on VBA in Excel 2010,

"VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy Syrstadcheck out the book, “VBA And Macros: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.



For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

“The Learn Excel from MrExcel Podcast Series”