Count Occurrences and Print Total

L

Lilbit

I have a spreadsheet that sorts data by officer name. The name is always
in the same column. Every time a name changes, there are two blank rows.
On the row after the last occurrence I need to see (right justified), for
example, Total: 3. This would mean that the name above Total occurs 3
times. How can I accomplish this? Thanks in advance for your help!!
 
L

Lilbit

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!!
 
Top