I am having trouble figuring the proper way to format a spreadsheet. This spreadsheet's data varies daily and I am looking for a way to sum totals from a column if it meets certain criteria from another column. The problem I get is that I have to paste the formula to every cell, because of the data varying daily. This causes a lot of duplicate entries.

I know there is a better way for me to do this, I just don't have the knowledge of it.

Can anyone help?