I have a PivotTable with many rows. The last row of the PT is, of
course, the sum of each column. I want to put a row of formulas a few
rows below the PT that counts the number of items in each column. The
number of rows fluctuates from day to day but stays roughly in the
forties. Also, there will not be a data point in every row that shows
each day.
Have a look at the COUNTA() function...
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion