Kathi,
I have posted an example at
http://cjoint.com/?cikz55RNFI that shows the SUM
and the SUIMPRODUCT solutions.
Take a look at these and let us know if you still have the problem.
BTW, I changed the date style, as yours didn't work for non-US style dates,
mine is more generic.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"kathi" wrote in message
...
I'm still getting zero response figures!!?!?!? HELP
"Bob Phillips" wrote:
That is probably because it is an array formula, and when you changed it
you
didn't re-enter as an array formula. To do so, it should be committed
with
Ctrl-Shift-Enter, not just Enter.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"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"))