Hey there,

I have looked through this forum and cannot find a Thread on this, apologies if I have missed it!

I have an excel sheet of ticket information. So far there are 2000 rows.

I would like a total of row entries. I have been using COUNTA, however I would like this value to change when more tickets are added. I would also like it to change when the data is filtered.

Can this be done please? I cannot find any articles online to help with the searches I've done.

Thanks!
TerranceT