Monthly Raw Data of Quantity – Purchase & Sales with date-wise
Formula: =SUMIFS(C:C,B:B,”>=”&G5,B:B,”<=”&EOMONTH(G5,0))
After Formula Applied – Monthly Stock Summery with Opening & Closing Balance
Video Tutorial
Download Stock Sheet with Formula (Download.xlsx)