Countif with range name

  • Thread starter Thread starter gabch
  • Start date Start date
G

gabch

Hi,

How can I set the validation like this formula?
=countif(rngCheckColumn, CheckCelladdr)<=
 
Assuming A1:A10 is the range of concern, give it the RangeName of "TheRange",
by highlighting it and doing Insert > Name > Define > and typing "TheRange"
(without quotes) in the small upper box of the pop-up.

Then assuming B1 is the cell you wish to validate, click on it and do Data >
Validation > choose Custom in the Allow: window > and in the Formula: window
type =COUNTIF(TheRange,B1)>=1 and click OK

hth
Vaya con Dios,
Chuck, CABGx3
 
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

Excel Need Countifs Formula Help 0
Finding the weighted average of text that have been given values 1
countifs Function not giving desired result with date criteria 2
Countifs 5
Countif gone wrong 2
Multiple arguments 1
Countif with a Range of criteria 8
Sumproduct not working 5

Back
Top