Thursday, November 21

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))

Leave a Reply

Your email address will not be published. Required fields are marked *