Here i have explained a trick that will ease your office work. you can use the Table option to drag all formulas automatically. kindly watch the video and learn the function to faster your work.
Solution Video
Download Project File for Practice (.xlsx)
Download more Excel Project File