Hi!

Blank rows won't cause a problem.

Check that the dates in column B are true Excel dates and not just text
entries that look like dates. True Excel dates are really numbers that are
just formatted to look like dates.

Also, check to make sure that the employee numbers in column C are also true
numbers and not just text strings the look like numbers.

You may as well check the values in column J for the same thing.

There's nothing wrong with the formula so you have to look at the data.

Biff

"Curtis" wrote in message
...
Not in columns B, C, or J, but there is $0.00 values in column J.
Yes Header is not in Range





"Govind" wrote:

Hi,

Are there any blank rows in your range of 2 to 1000? If yes, then the
formula might return an error. also I presume the header row is kept out
of your range.

Govind.


Curtis wrote:
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: J100))

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