Adding up colomns

Hi Jane

Thank you for your question. One approach would be to convert your list to a table.

The process is quick - I suggest you test it on a backup copy of your data first.

Click into your list, below the header (or title) row and on the Home ribbon click on Format as Table (in the Styles group).

Pick a format for your table from the list that appears
Check the selected range is correct then click OK
From the Table Tools ribbon on the Design tab click Total Row (you'll find it in the Table Style Options group)
Lastly go to the bottom of the column that has entries you would like to count. Click in the cell on the Total Row that corresponds with the bottom of the column to be counted.
You will see a drop down arrow. Click on this arrow and choose Count.
You may also need to click on any totals the Total as auto added to remove them from other columns in your table.

Now when you apply a filter to your list you will get an accurate count

Let me know if this works for you or if you have further questions.

Kind regards,
Andrew