Help with formula

[cayang68]

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

 

[T. Valko]

Try something like this:

=SUMPRODUCT(--(A1:A10="path_rep"),--(B1:B10="Con mtce"),--(C1:C10="Path_rep
FALSE"))

Adjust the ranges to suit.

Better to use cells to hold the criteria

E1 = path_rep
F1 = Con mtce
G1 = Path_rep FALSE

=SUMPRODUCT(--(A1:A10=E1),--(B1:B10=F1),--(C1:C10=G1))