I have the following formula in workbook BUDGET:

=SUMPRODUCT(--('[Paycheck.xls]2007'!$B$10:$AA$10=MONTH(A3)),'[Paycheck.xls]2007'!$B$17:$AA$17)

As you can see, it is looking in workbook PAYCHECKS for certain data. In
the PAYCHECKS workbook, range B10:AA10 contains a date (each column in row)
that a paycheck is received. The range B17:AA17 is the gross pay of each
paycheck.

MONTH(A3) is the date , ie 1/1/07 (formatted JAN-07) in BUDGET.

I am wanting to take the month value of A3 and sum the corresponding gross
pay recieved within that month. However, I do not know how to, or if you
can, use the MONTH function for a range, ie MONTH(B17:AA17).

Is there some way to do this or do I need to figure something else out?

Thanks,
Les