countif - sumif
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$14H12))
"emmbee" wrote:
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
|