View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lilbit
 
Posts: n/a
Default Count Occurrences and Print Total

Thanks for your response. Taking out the blank lines, sorting by Name, and
choosing Data, Subtotals worked for the most part. However, I can't choose
Use Function: Count for the Name column and Use Function: Sum for the Fees
and Assets columns at the same time and when I try to do the count first
and the sum second, it wipes out the count. Your help would be greatly
appreciated!!