Convert Boolean Array to an Integer Array

Gotchya, I see what you're saying, problem is the range that I initially pull in has varying data types not just boolean. So for instance I'll grab all the data from a work sheet and then just need to summarize it in different ways based on other inputs or limit inputs in other areas in the workbook.

So right now it really looks the take the VBA generated Boolean array and pushing it to a named range and then evaluating that named range into the VBA array and then deleting the named range is the most dynamic (non-looping) way of conversion. The Join * Evaluate mechanism fails when you have just one element, so you'd have to write a condition. but if I knew there would always be >1 Join * Evaluate seems pretty awesome