wildcards with sumif/countif in macro/vba

[Stefanie K.]

I know that you can use * as a wildcard with sumif and countif
functions in excel worksheets, but I was wondering if it's also
possible in macros/vba.

For example:
Application.SumIf(Range(Cells(1, 32), Cells(433, 32)), "*.aa.1t",
Range(Cells(1, 17), Cells(433, 17)))

Is this possible? If not, alternatives to this would be greatly
appreciated.
Thanks,
Stefanie

 

[Frank Kabel]

Hi
yes you can. Your statement should work. Have you tried it?

 

[Bob Phillips]

Stefanie,

If you tried it and it didn't work, it may be that the worksheet is not
active, so try fully qualifying

With Worksheets("Sheet1")
Application.SumIf(.Range(.Cells(1, 32), .Cells(433, 32)),
"*.aa.1t",.Range(.Cells(1, 17), .Cells(433, 17)))
End With


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)