I am attaching file which we are working on daily bases and need to report in the evening. at the moment with my simple formula it is working good but if i change any row for date change then i have revised my report. i tried to use pivot table but it is also not working the way we want reporting. Thank you so much for always helping in this forum. please find attached file.