View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jacquesbardot30@gmail.com is offline
external usenet poster
 
Posts: 2
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.