Count values bigger than cell

M

Micos3

Hello

I have a table B11:K40 and i want to count every cell's that is over the
cell value D52.
How can i do this?

thanks in advance
 
B

bigwheel

Micos3 said:
Hello

I have a table B11:K40 and i want to count every cell's that is over the
cell value D52.
How can i do this?
Click to expand...

Check out the Countif worksheet function - COUNTIF(range,criteria)
 
M

Micos3

You're right, but this function only counts in column and i need to count in
all the table, or perhaps i'm not doing it right.
i made to test:
A2:C5 and in A7 i wrote =countif(A2:C5;">A8") but the count were wrong, what
i'm i doing bad? he should count all values in table bigger than A8, or not?

"bigwheel" escreveu:
 
M

Micos3

I've found the awnser in an previous question:

=countif(A2:C5;">"&A8)
and it works cos i've tested
Thanks

"Micos3" escreveu:
 
Top