Not COUNTIF but SUMPRODUCT
And let's be careful how we refer to dates
=SUMPRODUCT(--(G2:G1238="O"), --(H2:H1238<DATE(1985,12,31)), --(H2:H1238DATE(1985,1,1)))
will count how many records have the O and dates between those specified

To include the first and last date
=SUMPRODUCT(--(G2:G1238="O"), --(H2:H1238<=DATE(1985,12,31)), --(H2:H1238=DATE(1985,1,1))
)

If you want O or MV
=SUMPRODUCT(--((G2:G1238="O")+(G2:G1238="MV")), --(H2:H1238<=DATE(1985,12,31)),
--(H2:H1238=DATE(1985,1,1)) )

The double negation for the first term is not needed
=SUMPRODUCT(((G2:G1238="O")+(G2:G1238="MV")), --(H2:H1238<=DATE(1985,12,31)),
--(H2:H1238=DATE(1985,1,1)) )


More info:
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html
Debra Dalgleish
http://www.contextures.com/xlFunctio...tml#SumProduct

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"Pat318" wrote in message
...
I'm trying to countif in 2 columns 1has "O" or "MV". The other column has
date ranges.
So if dates 1/1/1985 -12/31/1985 "O" count how many. And do the same for
"MV" within the same date range. Here is the formula im using. Not sure if
I'm on the right track. It 's not working....
=COUNT(IF((G2:G1238="O")*(H2:H1238<12/31/1985)*(H2:H12381/1/1985),H2:H1238))