Mr. Boyd:

I'm not sure I have the right understanding... To count a row based on
two columns in the row, you could use a compound logical and a COUNTIF:
              A       B         C                     D
---------------------------------------------------------------------
ROW 1         1       2       =AND(A1=1,B1>1)  =COUNTIF(C1;C5,TRUE)
ROW 2         2       0       =AND(A1=1,B1>1)
ROW 3         7       2       =AND(A1=1,B1>1)
ROW 4         3       1       =AND(A1=1,B1>1)
ROW 5         1       0       =AND(A1=1,B1>1)


--
|Suzanne K. Perez                   Telephone: (703) 525-7557
|
|Strategic Memory Solutions, Inc.   Fax:       (703) 525-7551
|
|1925 North Lynn Street, Suite 900  mailto:  [log in to unmask]
|
|Arlington, Virginia 22209          http://www.strategicmemory.com
|