SUMPRODUCT

Dueling Excel – “Address of Matching Cells”: Podcast #1641

               

Find That Address without A GPS!

MrExcel At The ModelOff Championships – “Sum / Average Multiple Criteria”: Podcast #1618

               

“And what does ‘Control + R’ do, exactly?” Find out!”

Looking Up Multiple Criteria with INDEX and SUMPRODUCT

               

JP Pinto won the fan-favorite Great White Shark award for his previous post about Cascading Validation Lists. The folks at the Office Online blog asked JP to do a new guest post for the Excel blog and JP’s post on using INDEX and SUMPRODUCT to do a two-criteria lookup is now available here. This looks(…)

Dueling Excel – “Total All Lookups”: Podcast #1513

               

Extreme LOOKUP Podcast Duel

Learn Excel 2010 – “Count Between Ranges – with A Pivot Table”: Podcast #1511

               

Use a Pivot Table to Count Between Ranges

Learn Excel from MrExcel