Counting te days worked in a month

C

Curtis

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

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

note: 2004-JAN_05 is one sheet

I need help with a formula that will track the number of days worked by
employee referenced to each sheet.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting the days worked in a month by employee 0
Multiple Condition Help needed.... 1
Multiple Conditions 0
Formula Help 5
Counting # of entries for each month, in a specific status 3
SUMPRODUCT by Date 3
Counting # of days worked 8
How to calculate worked weekend days 3

Top