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
Attachment | Size |
---|---|
Q1.xlsx | 12.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