Multiple Condition Help needed....
 

I currently use the following formula to track employee earnings.

=SUMPRODUCT(('2004-JAN_05'!$C$2:$C$20000=$A43)*('2004-JAN_05'!$J$2:$J$200000)*'2004-JAN_05'!$J$2:$J$20000)

Where
Column C represents the emplyee
Column J represents the earnings

I need to add another condition that adds the month to the criteria ( that
would be in cloumn B). Note cloumn B contains days for any given month so I
need to total all earnings by employee by month.

Thanks

Multiple Condition Help needed....
 

Curtis,

For January.

=SUMPRODUCT(('2004-JAN_05'!$C$2:$C$20000=$A43)*('2004-JAN_05'!$J$2:$J$200000)*(month('2004-JAN_05'!$B$2:$B$20000)=1)*('2004-JAN_05'!$J$2:$J$20000))

Change the =1 in the second condition to match the month number for
Feb-December. (2-12).


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=522800