I am using the following fomula below to calculate the sum of the number of
times the value of 1 is returned in cloumn g based on the conditions below.
However it returns an error of #VALUE!.

Column J contains employee ID's
Column b contains a value of 1 if certain conditions are met
Column G contains a value of 1 if certain conditions are met

=SUMPRODUCT((('Employee Data'!$J$5:$J$260=$A33)*('Employee
Data'!$B$5:$B$260=1)*('Employee Data'!$G$5:$G$260=1)*('Employee
Data'!$G$5:$G$260)))


Thanks

ce

You don't need the final range

=SUMPRODUCT(('Employee Data'!$J$5:$J$260=$A33)*
('Employee Data'!$B$5:$B$260=1)*
('Employee Data'!$G$5:$G$260=1))

but that apart, it works fine, so there must be some problems with the data.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Curtis" wrote in message
...
I am using the following fomula below to calculate the sum of the number
of
times the value of 1 is returned in cloumn g based on the conditions
below.
However it returns an error of #VALUE!.

Column J contains employee ID's
Column b contains a value of 1 if certain conditions are met
Column G contains a value of 1 if certain conditions are met

=SUMPRODUCT((('Employee Data'!$J$5:$J$260=$A33)*('Employee
Data'!$B$5:$B$260=1)*('Employee Data'!$G$5:$G$260=1)*('Employee
Data'!$G$5:$G$260)))


Thanks

ce

I thought I treid that...

Thanks

"Bob Phillips" wrote:

You don't need the final range

=SUMPRODUCT(('Employee Data'!$J$5:$J$260=$A33)*
('Employee Data'!$B$5:$B$260=1)*
('Employee Data'!$G$5:$G$260=1))

but that apart, it works fine, so there must be some problems with the data.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Curtis" wrote in message
...
I am using the following fomula below to calculate the sum of the number
of
times the value of 1 is returned in cloumn g based on the conditions
below.
However it returns an error of #VALUE!.

Column J contains employee ID's
Column b contains a value of 1 if certain conditions are met
Column G contains a value of 1 if certain conditions are met

=SUMPRODUCT((('Employee Data'!$J$5:$J$260=$A33)*('Employee
Data'!$B$5:$B$260=1)*('Employee Data'!$G$5:$G$260=1)*('Employee
Data'!$G$5:$G$260)))


Thanks

ce