countif - sumif

[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

 

[dperez6811]

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))