Multiple Condition Help needed....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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$20000>0)*'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
 
Curtis,

For January.

=SUMPRODUCT(('2004-JAN_05'!$C$2:$C$20000=$A43)*('2004-JAN_05'!$J$2:$J$20000>0)*(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 fo
Feb-December. (2-12).


HTH

Stev
 
Back
Top