SUMIF in VBA on VBA variables?

[Don Wiss]

I need the functionality of SUMIF in my VBA code. But not for a range.
These are Variant variables (two vectors of same length and a criteria).
For now I'll loop.

Don <donwiss at panix.com>.

 

[Bob Phillips]

You could drop them into a worksheet range and then use SUMIF from within
VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)