Calculating a % for a newbie ???

F

FISH

I'm still very much learning Excel (using 2002) and need to figure out how
to add a percentage of results that are continuously changing. I'll try to
be as clear as I can:

I have a spreadsheet that tracks results of events. I want to be able to
find out what percentage of the total events were finishes in the top 3. I
have separate columns that have the running total of events and the result.

I want to be able to add a function that will divide the number of finishes
in the top 3 by the total number of events (even though the total number of
events are constantly increasing.

More about my spreadsheet:
I have the total number of events starting in F6 and constantly increasing
down column F (now at F 238). I have the results starting in K6.

I have a function that already calculates the number of events where the
finish was 1,2,or 3 in N2.


I just don't know how to do this with the total number of events changing
(and the cell with that total also changing)


Thanks for any help...
 
P

Paul Sheppard

FISH said:
I'm still very much learning Excel (using 2002) and need to figure out
how
to add a percentage of results that are continuously changing. I'll try
to
be as clear as I can:

I have a spreadsheet that tracks results of events. I want to be able
to
find out what percentage of the total events were finishes in the top
3. I
have separate columns that have the running total of events and the
result.

I want to be able to add a function that will divide the number of
finishes
in the top 3 by the total number of events (even though the total
number of
events are constantly increasing.

More about my spreadsheet:
I have the total number of events starting in F6 and constantly
increasing
down column F (now at F 238). I have the results starting in K6.

I have a function that already calculates the number of events where
the
finish was 1,2,or 3 in N2.


I just don't know how to do this with the total number of events
changing
(and the cell with that total also changing)


Thanks for any help...
Click to expand...

Hi Fish

Try this - =COUNTA(F:F) in a suitable cell, it will count the non blank
cells in column F, If row 1 contains a heading that you don't want
counted changew the formula to =COUNTA(F:F)-1
 
B

Bob Phillips

=N2/COUNTA(F6:F65536)

and format as a percentage

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top