title: Count by multiple criteria not working
body: <p>I have the below table i neeed to count the no.of.triggers that are enabled.</p>
  
  <pre><code>TABLE NAME OBJECT TYPE STATUS   
  factory     Triggers    ENABLED 
  PRODUCT     Packages    ENABLED
  REFERE      Triggers    ENABLED
  </code></pre>
  
  <p>In 2007 i tried below but they are not working what i am making mistake in this ?</p>
  
  <pre><code>=COUNTIFS(D:D,"Triggers",F:F,"ENABLED")
  </code></pre>
  
  <p>I need a 2003 compatibile formula since COUNTIFS is introducted only in 2007 i tried the below query for 2003 again they also yeileded "0". clearly i am missing some thing here.</p>
  
  <pre><code>=SUMPRODUCT((D:D="Triggers")*(F:F="ENABLED"))
  </code></pre>