SUMPRODUCT - Adding New Data Daily

[BigErnKingpin]

Hi,

I was wondering the best way to update a spreadsheet where I have multiple columns with agent performance data being added on a daily basis.

I have summaries below the main data where I am using the SUMPRODUCT function to adjust the running totals but it is proving to be very cumbersome leaving me having to manually go in and overkey the row value for every single column. Is there a way I can have these update automatically using ranges or something and if so how do I do it?

I would usually just churn all this through a pivot table but my boss is insisting this is how he wants it is to be done.

I have attached a screenshot for reference.

Thanks a lot