How to use OFFSET Function in Excel | Basic to Advance

[@wrongturnlima007]

Explained so easy...... 🙏

[@PowerExbyJitendra]

Thanks a lot

[@Aditya7080]

Thank you sir

[@PowerExbyJitendra]

Welcome

[@RshbComics]

This is literary too good..

[@PowerExbyJitendra]

Thanks

[@syedikramullah1114]

Nice

[@PowerExbyJitendra]

Thanks

[@tanzeem7477]

Hi sir, month wise total sum kese nikal skte h example:- hm agr October select krte h to January to October ka total sum or agr March select krte h to January to March ka total sum.. Please help.

[@ankursharma6157]

Hi @tanzeem7477,
Please check:
Cell A1 में header है MONTHS.
Range A2:A13 में months हैं.
Cell B1 में header है SALES.
Range B2:B13 में amounts हैं.
Cell D2 में Data Validation drop-down है जिसमें से month select करेंगे.
Formula है: =SUM(OFFSET(A1, 1, 1, MATCH(D2, A2:A13, 0), 1))
Hope, it helps.

[@tanzeem7477]

@@ankursharma6157 thank you