Try
=SUMPRODUCT(--('REAR D'!$C$2:$C$500="10/01/05"),
--('REAR D'!$C$2:$C$500<="12/31/05"), --('REAR D'!$B$2:$B$500="F"))


for details see on SUMPRODUCT
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"kathi" wrote in message
...
column A has dates, column B has a,b,c,.......
I need to count by Fiscal Year Quarters (10/01/05-12/31/05)only those that
have an F in column B.
I had been using this formula array, for some reason I can't change,
alter,
copy paste or do anything to it. The input has change but the output
hasn't.
If I remove the column B reference I still get the correct result of all
between those dates, but as soon as I ask for only those with F.....
=SUM(('REAR D'!$C$2:$C$500="10/01/05")*('REAR
D'!$C$2:$C$500<="12/31/05")*('REAR D'!$B$2:$B$500="F"))