Countif Criteria Problems

[sheetal211]

I am using the countif funcition in Excel, but am having problems with
the criteria operation of it. the code is

=IF(G7="","",COUNTIF(O7:FI7,">G2")) however, I want the G2 to change
when in another cell. I know you can put values in there, but I want
to select a cell and want excel to acknowledge it.

Is there any way this could be resolved?

Thanks

 

[Chip Pearson]

Try

=IF(G7="","",COUNTIF(O7:FI7,">"&G2))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[sheetal211]

Thank you very much for the solution to the Countif Problem.

Another question, its quite similar, when you are in VLOOKUP, and a
range has been selected, how can you avoid the values in the range to
change as you select down the column?

Thanks again

 

[Chip Pearson]

I don't really understand your question. Perhaps you can use absolute
referencing, putting $ characters in the cell addresses. E.g., $A$1:$A$10 .
Maybe if you provided more detail about what you want to do, someone can
provide a better answer.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Paul]

Thank you very much for the solution to the Countif Problem.

Another question, its quite similar, when you are in VLOOKUP, and a
range has been selected, how can you avoid the values in the range to
change as you select down the column?

Make the range addresses absolute rather than relative. That is, $A$1
instead of A1, and so on.