I have space rows all over the place... would that affect the headings.
My headings are on row 4 but there is nothing in rows 5 and a space row
after each sub total.
As I read the description of DCountA... The 3 parameters could be
(Range1,Cell,Range2)... where Cell is the top column of the data being
searched and Range2 is a range of cells containing criteria that has a
heading the same as Cell.
Do you think I'm reading correctly here?