So I am am looking to build a tracker that monitors sales each day, and I’d like a formula that updates the total sales for a month automatically.
Currently we have individual dates of a month in columns, so 01/03/2021 (dd/mm/yyyy) will be in column B, 02/03/2021 in column c and so on... In column A I have the names of agents, and the sales that they achieved will show under the days previously mentioned. E.g. Kyle had 22 sales showing under 01/03/2021, and then 17 sales under 02/03/2021.
I would to have a formula that then counts up all the sales an agent has achieved automatically counts up to the date of whenever i check it, so I don’t have to update the formula each day.