Count values bigger than cell
 

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

"Micos3" wrote:

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?


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

=
"Micos3" wrote in message
...
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

=COUNTIF(B11:K40,""&D52)
or
=COUNTIF(B11:K40,"="&D52)
Regards,
Alan.
"Micos3" wrote in message
...
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

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:

"Micos3" wrote:

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?


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

I've found the awnser in an previous question:

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

"Micos3" escreveu:

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:

"Micos3" wrote:

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?


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