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.

[youtube=http://youtube.com/watch?v=yfz1DVl8cc4]

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