Double unary minus. Converts the logical TRUE or FALSE to number 0 or 1 so
that it can be multiplied..
--
David Biddulph

"WLMPilot" wrote in message
...
One other little question: What are the two dashes for prior to the first
MONTH() function?

Les



"Toppers" wrote:

try:

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

"WLMPilot" wrote:

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