sumif in VBA

[lu fim]

Need a little help with a simple sumif. I dont know why it keeps telling me the Sumif formula has a sintaxe error.

Please Login or Register  to view this content.

It sais it expected a text separator were i input colum S:S.

This looks like a very simple problem, but i couldnt find anything alike here in the forum, and i cant solve it.

Please Login or Register  to view this content.

[6StringJazzer]

On the right side you are missing a close quote and a close paren, and the left side the quote is in the wrong place:

Please Login or Register  to view this content.

[lu fim]

haha i knew it was just something stupid. Thank you

[lu fim]

I fixted it, but it is giving me error '438' - object doesn't support this property or method

[6StringJazzer]

I found a couple more errors after my original post and edited my response. You may have copied my response before I made those changes. Are you using the latest version? Please try again.

If it still doesn't work, show exactly what you are using and give the value of rw when the error occurs.

[lu fim]

I forgot to mention i use excel 2002. But I would guess this function is available to this version anyways.

i've tryed a few things, and it keeps sending the same msg.

Please Login or Register  to view this content.

[bakerman2]

I forgot to mention i use excel 2002. But I would guess this function is available to this version anyways.

Simple answer. NOPE

You will have to turn to SumProduct.

[lu fim]

So excel 2002 does not suport sumif in VBA? I can do the sumif funtion in the normal excel, it only gives me this messege while i try to insert the function in visual basic mode. Then if this is the case, how could I get this done with other formulas?

[6StringJazzer]

Sorry, didn't realize that was not available in 2002. I have not used VBA in any version prior to 2003.

SUMIFS was introduced in Excel 2007. You are only using one criterion so you could use SUMIF (you must change the syntax to match). If SUMIF is not available in your version of Excel, this is how you could use SUMPRODUCT:

Please Login or Register  to view this content.

I can't test this properly without your file but give it a try.

[lu fim]

GOT IT! its not 'sumifs'... its just 'sumif'

thank you!