Multiple Conditions

C

Curtis

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 A represents the emplyee
Column 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
 

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

Multiple Condition Help needed.... 1
Counting te days worked in a month 0
Counting the days worked in a month by employee 0
Formula Help 5
Sum with multiple conditions 6
Help with altering a formula 3
Writing a formula which dynamically generates results 5
Calculating the sum with multiple conditions 4

Top