Excel 2007 : Count funtion

Hi there,

i really need help with this problem i am having. outlined below.

--------------

I have a list of cells, D32:D62. Each cell has a number in it.

I have another cell, D6, that i use to get data from D32:D62
In cell D6 i have a countif function to count every cell over or equal to the number 1.

D6=COUNTIF(D32:D62,">=1")
this reports to me that their are 22 values over or equal to no.1

I now want D6 to do the same count but exclude the highest value in D32:D62

I want it to return the number 21

i can not add -1 after the equation ie (=COUNTIF(D32:D62,">=1")-1)
because i need to use the output from d6 in another cells formula

i also cant do
COUNTIF(D32:D62,">=1")-MAX(D32:D62)

that formula takes the number 22 and then subtracts the value of the actual highest cell. I.e. 22- 19. Which gives an output of 3.

I dont want it to subtract the value of the cell from the overall count. I want it to not count it.



Does anyone have the answer for this?

Perhaps try

=COUNTIF(D32:D62,">=1")-(MAX(D32:D62)>=1)

thanks!
that works

do you know how i would subtract the top 2 max numbers and top 3...

last question!

how do i use that formula (provided by daddylonglegs) but change it so it subtracts the highest 2 numbers.
or the highest 3,4, or 5 numbers
whichever i decide

thanks!
greatly appreciated

anyone know this?
it would be a big help
thanks