How to Enter All Sheets Monthly Total Summery in a New Sheet

Raw Data of Daily Sales in different-different monthly Sheets 

April May June July Sales Report in Excel

Formula:  =VLOOKUP(“TOTAL”,INDIRECT(B3&”!A:D”),2,0)

Output After Applied formula to make Monthly Summary

Monthly Sales Summery Report in Excel

Video Tutorial

Download Practice File with Formula (Download.xlsx)

Download Excel File

Download more Excel Project Files

Leave a Comment