countif - sumif

  • Thread starter Thread starter emmbee
  • Start date Start date
E

emmbee

am looking to count a number of cells containing the same data in a row but
only if the individual cells fall within a certain date range
 
Use the countifs in excel 2007.
H12:14 range you want to evaluate
(range 1, test 1, range 2, test 2)
=COUNTIFS($H$12:$H$14,"<3/1/09",$H$12:$H$14,">1/1/09")

If using excel 2003 use sumproduct:

=SUMPRODUCT((range1<reference last date)*(range2<reference first date))
=SUMPRODUCT(($H$12:$H$14<H14)*($H$12:$H$14>H12))
 
Back
Top