formula for creating percentages

  • Thread starter Thread starter dolingercha
  • Start date Start date
D

dolingercha

I have 300 individual spreadsheets that need a simple
formula created to figure the amount of clients each coach
has and what percentage of those clients sends in monthly
stats reports. If anyone can help with the formula to
figure what the percetage using the stats analysis system
would be it would be greatly appreciate.
 
You'll need to provide more details about how the data is layed out, i.e.
some example lines.
 
I currently have one spreadsheet that gets updated on a
monthly basis and the CEO now wants to be able to track
the number of clients using the analysis system is
provides, so the columns are as follows:

a member name
c state
e coach name
f month/year
g services and then the rest of the columns contain stats
like g
I need to figure out the formula to show the total number
of clients by coach and then the percentage that sent
stats in which would be reflected with number appearing in
columns g:m, if the client did not sends stats in of
course columns g:m remain blank.



Original Message-----
 
Back
Top