I currently use the formula to calcualte the $$ earned by employee per month.
The data is captured monthly in multiple sheets in a workbook. 1 sheet per
month)

To calculate the montly rev by employee I use the following;

=SUMPRODUCT(('2004-JAN_05'!$C$2:$C$20000=$A36)*('2004-JAN_05'!$J$2:$J$20000<0)*'2004-JAN_05'!$J$2:$J$20000)

2004-Jan_05 = the first sheet with the month being January
$A36= the employee


I need help with a formula that will track the number of days worked by
employee $a36t in the month of Jan

Please and Thanks