that seem to be working. Thanks

"Harlan Grove" wrote:

Brad wrote...
....
I tried using the following formula =SUMPRODUCT(--(July!A:A='Payroll
Summary'!A2),--(July!G:G=C1),July!I:I) But all I get back is #NUM! error.

The problem is that SUMPRODUCT doesn't support entire-column ranges.
You can use ranges or arrays with 65,535 rows, but not ones with 65,536
rows. On the assumption you'd be using a real database if you had to
keep track of +60K records like this, I'll assume you could get by with
rows 1 through 65535. Change your formula to

=SUMPRODUCT(--(July!$A$1:$A$65535=$A2),--(July!$G$1:$G$65535=C$1),
July!$I$1:$I$65535)