It returns a value of 0 no matter what month is selected (=2, =3, etc).. Same
with Employee #

used formula

=SUMPRODUCT((Raw2!$C$2:$C$1000=2386)*(MONTH(Raw2!$ B$2:$B$1000)=4)*(Raw2!$J$2:$J$1000))




"Govind" wrote:

Hi,

Use

=SUMPRODUCT((C:C100=EMPLOYEE NO.)*(MONTH(B1:B100)=MONTH YOU NEED)*(J1:J100))

where C1 to C100 is the range with employee no.s , B1 to B100 is the
range with dates and J1 to J100 is the range to be summed up. Lets say
you need data for employee no. 500 for the month 2 -February, use

=SUMPRODUCT((C:C100=500)*(MONTH(B1:B100)=2)*(J1:J1 00))

Govind.

Curtis wrote:

I need to calculate the sum of numbers that are dependent on 2 conditions. One
Condition is employee number (in column C) and the other condition is the
month (in column B) €“ Column B contains dates listed by day.

I would like to calculate the sum (listed in column J), by month for a
specific employee.

There will be multiple sheets within this workbook. One sheet will report
the data as identified above and the others will contain the raw data (these
worksheetes will be quite large).

Thanks