Help! Need formula to count values based on the date that they occured

Copper Contributor
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.
2 Replies

I have attached an example tracker, it's very basic but should help answer my query.

 

Thanks

@DBreezy92 

In L2:

=SUMIF($B$1:$K$1,"<="&TODAY(),B2:K2)

Fill down.