|
|
#1
05-22-2011, 09:31 AM
|
|||
|
|||
Countif with 2 criteria
=COUNTIF($G$2:$G$19,G8)=1
I want to edit the above formula to inject AND to make 2 criteria This did not work: =COUNTIF(AND(($G$2:$G$17,G8)=1)G8 <>"") What I want to happen is for the cell not to accept any input if G8 is not repeated and/or blank. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Criteria in Outlook Search | Nancy Grams | Outlook | 0 | 11-12-2009 03:03 PM |
 Sort by criteria: number of results
|
p0k | Excel | 1 | 10-22-2009 08:33 PM |
| How to count cells containing data and meet certain criteria | AdamNT | Excel | 1 | 08-11-2006 11:51 PM |
|
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
|
Filtering past or future events in DRW query criteria
|
jvieille | Misc | 1 | 02-11-2006 06:26 AM |
Windows Vista 
Office 2007
Threaded Mode