Overview Chat Bike Members News Women
Viewing 4 posts - 1 through 4 (of 4 total)
  • microsoft excell formula help please
  • karnali
    Free Member

    i have a list of perecntages in a column (about 200) and i need to be able to give a total at the bottom of the number of entreis that are above 85% is there a formula i an use that will do that and give me a total

    cheers

    Posted 13 years ago
    TheSouthernYeti
    Free Member

    Countif

    Posted 13 years ago
    damo2576
    Free Member

    or sumif if you want to sum rather than count

    Posted 13 years ago
    pennine
    Free Member

    =COUNTIF(A1:A5,”>.85″)

    Posted 13 years ago
Viewing 4 posts - 1 through 4 (of 4 total)

The topic ‘microsoft excell formula help please’ is closed to new replies.

Overview Chat Bike Members News Women