Thursday, February 6

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 *