View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Excel spreadsheet formula to count numbers in PivotTable column

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