Thanks for your help. For some reason I am getting a #REF error. Both
workbooks are in the same directory on a memory stick, which is in Removable
Drive E:. Does that matter?

Les



"Bernard Liengme" wrote:

Try
=SUMPRODUCT(--('[Paycheck.xls]2007'!$B$1:$F$1=MONTH(A3)),'[Paycheck.xls]2007'!$B$2:$F$2)
fix the cell references to suit your need
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"WLMPilot" wrote in message
...
I have two workbooks: BUDGET and PAYCHECKS.

In the BUDGET workbook are 12 budgets (ea month). Beside each monthly
budget is a statistical section. I will reference Jan & Feb budget info
for
this question. Though the format for A3 & A57 (in BUDGET) is JAN-07 &
FEB-07
respectfully, the actual value is 1/1/07 & 2/1/07. I would like a generic
formula that could be copied to all 12 statistical sections of each budget
that would sum the gross (Paycheck workbook - B17:AA17) if the MONTH value
of
B10:AA10 (Paycheck Workbook) equalled the MONTH value of each budget, ie
A3,
A57.

I originally tried this formula in the appropriate cell in [BUDGET]:

=SUMIF([Paycheck]2007!MONTH(B10:AA10),"=MONTH(A3)",[Paycheck]2007!B17:AA17)

I figured you could not have a range with MONTH, ie MONTH(B10:AA10) but it
was the only start I had to try and figure it out. Needless to say, I am
stuck. I wanted this type of formula in an effort to minimize the change
within the formula as it is copied to each statistical section of the
budget
workbook.

I greatly appreciate any help on this!!!

Les