W
WLMPilot
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
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