I'm trying to create a spreadsheet that A) enters the number of projects worked on per day for several different kinds of projects, B) multiplies that number by a point value which differs for each different project, and C) sums the resulting values for the day. The goal is to be able to see daily totals over the course of a month.

In the first cell I only want the sum of projects done on Monday, Week 1, and in the cell below I only want the sum of projects done on Monday, Week 2, and so forth. The next column would be totals for Tuesday, Week 1, then Tuesday, Week 2, etc. I've been doing this by using SUM on all the individual multiplications necessary, but as we add more project types, it's getting to the point where there are too many arguments.

I've tried using sumproduct, but I can't figure out how to make it conditional--i.e. right now it's summing everything entered under the Monday column, regardless of what week it is. I'm sure there must be a way to do this, perhaps by using the IF function with SUMPRODUCT, but I can't figure out how to make them work together. Any suggestions would be much appreciated.