Hi,

can anyone help me with this problem please? (have included details required
first)

cell where IFSUM formula is to be placed = E15 ( where i need to create
formula)
cell where IFSUM item is located = D2 ( job No. 1234)
cell where other book name is = C15 ( this text is November 2005 )
other workbook location = S:\Purchasing\ ( then other book name )

i have written this macro-

sub GETWIP()
MonthEqual = range("C15").Select
monthcheck = "=SUMIF(S:\Purchasing\'[" & MonthEqual & ".xls]Front Order
Summary'C10:C1010,D2,[" & MonthEqual & ".xls]Front Order Summary'!F10:F1010)"
getjobcode = Range("C2").Value

if getjobcode = "Complete" Then
MsgBox " please enter job number in space provided"
Exit Sub
End If
if getjobcode < "Complete" Then
Range("E15").Value = monthcheck
End If
Exit Sub
End Sub

my normal workbook formula for this would be-
=SUMIF('[November 2005.xls]Front Order Summary'!$C$10:$C$36,D13,'[November
2005.xls]Front Order Summary'!$F$10:$F$34)
which takes "November 2005" from "MonthEqual" and compiles the formula to
cell E15.

i get an error highlighting Range("E15").Value = monthcheck.

basically, i am trying to compile a formula from the month, year & xls to
look at the job no value and find it in november 2005 workbook at location
specified, then return the value in the range required but i cannot get it to
work.

thanks in advance,

Nigel