And sometimes those characters are invisible to the naked eye--just more HTML
junk <vbg.

Peo Sjoblom wrote:

They actually do add some characters, sometimes I search for my own old
formulas and when I copy and paste them on some occasions there have been
things like an extra minus sign etc

--
Regards,

Peo Sjoblom

"Dave Peterson" wrote in message
...
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

--

Dave Peterson