Calculating a % for a newbie ???

[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...

 

[Paul Sheppard]

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...

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

 

[Bob Phillips]

=N2/COUNTA(F6:F65536)

and format as a percentage

--

HTH

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

 

[FISH]

THANKS...

=N2/COUNTA(F6:F65536)

and format as a percentage

--

HTH

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