Learn Excel Episode 842: SumIf a Range

Posted in Companies, Podcasts on September 12, 2008



Marc sends in an interesting question about SUMIF. Each time the value is equal to January, he wants to grab a five-cell range! SUMIF doesn't seem up to the challenge, but an array formula with OFFSET does the trick. Episode 842 shows you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Array Formula, Offset, SUMIF