Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif - sumif
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif / Countif | Excel Worksheet Functions | |||
COUNTIF?? SUMIF?? | Excel Discussion (Misc queries) | |||
Countif and sumif | Excel Discussion (Misc queries) | |||
{} SumIf and CountIf | Excel Worksheet Functions | |||
Countif, Sumif | Excel Worksheet Functions |