I am trying to count the number of entries within certain guidelines. Each
time I try I keep coming up with errors or incorrect answers.
A B L M N U Z
1835 61 12/03/2009 Conc Mtce Path_Rep Path_Rep TRUE
1836 0 12/03/2009 Conc Mtce Path_Rep Path_Rep TRUE
1837 0 12/03/2009 16/03/2009 Conc Mtce Path_Rep Path_Rep FALSE
1838 0 12/03/2009 16/03/2009 Conc Mtce Path_Rep Path_Rep FALSE
1839 0 12/03/2009 16/03/2009 Conc Mtce Path_Rep Path_Rep FALSE
1840 0 12/03/2009 16/03/2009 Eng Mtce Path_Rep Path_Rep FALSE
1841 31 12/03/2009 16/03/2009 Eng Mtce Path_Rep Path_Rep FALSE
1842 63 12/03/2009 16/03/2009 Eng Mtce Path_Rep Path_Rep FALSE
1843 19 12/03/2009 13/03/2009 Eng Mtce Sumps_&_ Sumps_&_ FALSE
1844 0 12/03/2009 Eng Mtce Kerb_Isl Kerb_Isl TRUE
1845 9 13/03/2009 Eng Mtce Path_Rep Path_Rep TRUE
1846 8 13/03/2009 16/03/2009 Conc Mtce Path_Rep Path_Rep FALSE
1847 7 13/03/2009 Conc Mtce Path_Rep Path_Rep TRUE
1848 7 13/03/2009 13/03/2009 Public_u Public_u FALSE

I think the formula should go something like
U N
If ((feat_name=path_rep) and (department=Con mtce) then count Path_rep FALSE)
Z

Any help would be greatly appreciated

Paul