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.


--
rahirah
------------------------------------------------------------------------
rahirah's Profile: http://www.excelforum.com/member.php...o&userid=30380
View this thread: http://www.excelforum.com/showthread...hreadid=500410