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