How to Put Conditional Sums in macros

[Alan P]

I am trying to use a macro to ad a conditional sum and am unable to do it or
decipher the VBA (alleged) help section. Usingthe wizard while in the macro
didn't work and I can't figure out a syntax that works. Can anyone point me
inthe right direction?

Thanks,

Alan

[Tom Ogilvy]

Range("A1").FormulaArray = "=Sum(if((B1:B200=5)*(C1:C200>6),1,0))"

--
Regards,
Tom Ogilvy


"Alan P" <AlanP@discussions.microsoft.com> wrote in message
news:46584DA0-C680-4D51-B64E-5F5B7F3A7323@microsoft.com...
> I am trying to use a macro to ad a conditional sum and am unable to do it
or
> decipher the VBA (alleged) help section. Usingthe wizard while in the
macro
> didn't work and I can't figure out a syntax that works. Can anyone point
me
> inthe right direction?
>
> Thanks,
>
> Alan