SUMIFS Function examples.By admin / May 23, 2014 What you will learn in this lesson? Difference between relative and absolute references using $ symbol while writing formulas Switching between relative & absolute refs. With F4 key View the lesson [6min.] Download Materials: Download this lesson: