DId really do it unless I am doing something wrong or did not give you enough
info.

SO far I have =SUMIF(APR_05!$C$2:$C$65536,$A37,APR_05!$J$2:$J$65 536)

this sums up the $$ by employee number. I need to add a formula that pulls
the $$ by the month as well keeping in mind that each row in the sheet has a date assigned to it which could represent any day of any month of any year.




"Dave R." wrote:

Try

=SUMPRODUCT((A1:A100=123)*(MONTH(B1:B100)=5),C1:C1 00)

123 = employee number
month = may (5th month)
c1:c100 is the range you want to sum if above 2 conditions are true on the
same row.

"Curtis" wrote in message
...
I need to calculate the sum of number dependate on 2 conditions. One
condition is emplyee number ( in a column of many numbers) and the other
is
the month (in a column listed with many days)