SUMIF Macro

[Boyler88]

Hi all,

I am wondering if anyone could advise me how i could make this formula run in VBA?

Seems there is no easy examples on the web of how to do this.

=SUMIF(Mysheet!B5,"<=-21",Mysheet!C5)

Thanks in advance.

 

[Andrew Poulsom]

Recording a macro while entering it manually will give you the syntax (in R1C1 reference style). Basically you need to double up the quotes.

 

[Boyler88]

Recording a macro while entering it manually will give you the syntax (in R1C1 reference style). Basically you need to double up the quotes.

Thanks alot of the help Andrew.

About 1 minutes before you replied i put two more quotes in and hey presto!

It was as easy as...
=SUMIF(Pivot!B5,""<=-21"",Pivot!C5)