
SUM Function With OFFSET Function In Excel
OFFSET Function is used to move or skip either row or column. Suppose you want to know what data available after every 2 rows or column the offset function is the best choice to get perfect result. It also used with other fucntion available in excel to make it more powerful. For example =SUM(OFFSET(A1,2,2,2,2))