Hi,

In the attached sheet i need to sum the daily sales record for indivusal sales person. Is there a way to make the dynamic width (single row) using Offset function of any other formula so that it only sum the data till the last non blank cell.

Dynamic Width.xlsx

Thanks
Rajesh