Bad Formula

[pclplante]

This is what I have so far and can't seem to make it work on a daily basis.

=SUMPRODUCT(SUMIF(INDIRECT("'"&1:10&"'!B42"),TODAY() - 1,INDIRECT("'"&1:10&"'!B42")))

Any help PLEASE!!!

 

[lehoullierk]

I apologize if I am using the forum incorrectly as this is my first post. I have an issue that is similar but I think much easier to resolve. I am new to VBA and am struggling to build a model that produces financial statements from linked data from Dynamics GP. My problem is that when I try to create a macro to paste a formula the macro parses the formula due to the existence of parenthesis in the formula. Sub PL_YTD_Feb()
'
' PL_YTD_Feb Macro
'
'
Range("C6").FormulaR1C1 = "=SUMIFS(INDIRECT(" 'Changes'!R2C"&MONTH(R3C1)+7&":R49987C"&MONTH(R3C1)+7,FALSE),Changes!R2C6:R49987C6,"=Sales",Changes!R2C1:R49987C1,"="&YEAR(R3C1))*-1+SUMIFS(INDIRECT("'Changes'!R2C"&MONTH(R3C1)+6&":R49987C"&MONTH(R3C1)+6,FALSE),Changes!R2C6:R49987C6,"=Sales",Changes!R2C1:R49987C1,"="&YEAR(R3C1))*-1"

End Sub

 

[lehoullierk]

the formula goes green after "=SUMIFS(INDIRECT("