Hi!
To help us help you, could you please prepare a reproducible example (reprex) illustrating your issue? Please have a look at this guide, to see how to create one:
Specifically in your case take a look at group_by + summarize functions in dplyr.
group_by
summarize
dplyr