You could try copying a copy of Peo's formula again (just in case google
introduced some funny characters).
=SUMPRODUCT(--($I$2:$I$200="Y"),
--(SUBTOTAL(3,OFFSET($I$2,ROW($I$2:$I$200)-MIN(ROW($I$2:$I$200)),,))))
(if that still fails, try typing it in manually.)
And if that fails, copy the formula from the formula bar and post it in your
reply.
wrote:
Yes, English. Excel 2007.
I tried the =SUMPRODUCT..... again. Still not working.
Thanks for looking at this Dave!
On Aug 15, 8:34 pm, Dave Peterson wrote:
Do you use an English version of Excel?
If no, what language do you use?
Dave Peterson
--
Dave Peterson