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?