Count values bigger than cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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)
 
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:
 
I've found the awnser in an previous question:

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

"Micos3" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=IF(Input_Sheet!D52="","",Input_Sheet!D52) 2
List Dependent Worksheet Functions 3
Conditional Format? 4
I want to write a formula with IF & AND & OR, (I think) 1
If 3
Defining an array to search by 4
Excel Need Countifs Formula Help 0
count cells in a document, but excude cells with a "0" 1

Back
Top