Learn Excel 2010 – “Sum Over Threshold”: Podcast #1480
Today, lets consider this question: Someone has a threshold value of $25000 in cell E1. We want to add up all the values in A2:A8 that are over the threshold. But…as a twist, how do we work with only those amounts in excess of the threshold? In Episode #1480 Bill shows how this can be accomplished.
…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: Excel 2010, Learn Excel 2007 through Excel 2010, Learn Excel 2010, MrExcel Podcast, MrExcel Products, New MrExcel Publication. Tags: 2010, accounting, Bill Jelen, business, Excel, Excel 2010, MrExcel, Range, spreadsheets, SUM, technology, threshold, tutorial, Worksheet.