Get Count and Total

Dear Excel experts,

I appreciate any help for this:
I wish to build a macro to get (Count/Total) for some values in specific columns those related to name in A column
For more details please find the example in attached file

Thanks in advance

AttachmentSize
Q1.xlsx12.73 KB

Get Count and Total

A macro is not really needed, although a macro can do what you want

If you include the names in column A in all cells you can do a SUMIF formula for column D, using column A as your filter. Was not sure what your COUNT1, COUNT2, COUNT3, COUNT4 data was

If you need help let me know
Marty