Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with formula
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)) -- Biff Microsoft Excel MVP "cayang68" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|