You can use filtering directly, sort by author first, then filter the authors, and finally summarize the authors (remember to choose the count). You can also use the function, but you must also filter out the author through screening, and then use the COUNTIF function for statistics. The first one is more automated and easier to use.

It's not clear yet. You can ask me again. You can explain the problem in detail and I'll give you some solutions.