COUNTIF

G

Guest

COUNTIF(range,criteria)
=COUNTIF(A2:A26,A32) would check the no. of times the value in A32 is
getting repeated in the range A2:A26.

How can i define the criteria - that the formula should check the no. of
time the value in the range exceeds the value defined in the cell A32 (> the
value entered by the user in A32). Which means that i want to have an option
that i can change the values in A32 (variable) . It should not be fixed.
Otherwise i could have given the criteria as a fixed no. rather than giving
the cell reference.
 

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

count 3
If Statement 2
cell reference formula 2
How to define range of values in a formula? 2
Excel Need Countifs Formula Help 0
get value from cell value 4 rows above in the same column 4
Search for specific number in a range 1
Activate Hyperlink in Named Range 2

Top