View Single Post
  #5   Report Post  
Micos3
 
Posts: n/a
Default

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)