Within this worksheet, I have 4 columns

Company Name #logs Boardmember
ABC Luis 1 yes
ABC Anne 1 yes
ABC Mary 9 yes
XYZ John 1 yes
XYZ Grace 4 no
XYZ Ben 8 yes
345 Erin 2 no
345 Kate 0 no
345 Greg 0 no

What I want to solve for is-
Board member Usage (#boardmembers with logs per company1/
#boardmembers per company)
Non Board member usage (#nonboardmembers with logs1 per company/
#boardmembers per company)

For example,
Usage
---------
Team ABC usage = 33%
Team XYZ usage = 66%
Team 345 usage = 100%

Is there a way to do this in a macro? My main problem is finding a way
calculate by company name. Any help would be great