You might be able to do all you want by using a pivot Table report on your
data.


another approach

=SUMPRODUCT(--(A1:A10={1,3,5}))

counts rows that contain a 1, 3 or 5 in A1:A10.

--
Regards,
Tom Ogilvy



"Wiley" wrote:

I have a spreadsheet which I need to return record counts based upon the row
containing any of 10 values in Column E. To make it worse, for a different
count, I will need to consder a subset of values in Column E as well. I
will need to do multiple variations of this tp establish a variety of metrics.

Yes, DB would be better, but not available to me.

I am just above the novice level. What VBA functions should I consider? Is
this a good use for an array? If so, some tips would be helpful. Or is
there a better (easier) approach?

Thanks for your help.