Hi,

I was trying to figure out how to use sumproduct in VBA in the same manner as in excel in lieu of CountIfs and/or Creating Arrays given criteria

Someone else noticed that VBA isn't converting Boolean Array into Integers automatically like Worksheet does. I looped through to keep it moving, but was wondering if anyone has ideas on converting

ex. Worksheet: Sumproduct((Array <> variable)*1)

So I'd hae to convert (Array <> variable) from Boolean to 1, 0)