Hey, this works great for something I'm doing as well. But I can't
understand how this works. Is there any chance you could explain what's
going on with this formula? I don't get it.

Thanks,

Jay

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Mr E" wrote in message
...
I would not have a clue why that works, but it does. Thanks

"T. Valko" wrote:

Try this:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(Q11:Q301,ROW(Q11:Q30 1)-ROW(Q11),,1)),--(Q11:Q301249))

--
Biff
Microsoft Excel MVP


"Mr E" wrote in message
...
Hi Shane,
the formula worked after I added another closure to the parentheses,
but
did
not return the proper answer. any idea?

"Shane Devenshire" wrote:

Hi,

=SUMPRODUCT(SUBTOTAL(3,OFFSET(Q11:Q301,ROW(11:301)-1,,1))*(Q11:Q301249)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Mr E" wrote:

is it possible to use countif in a range that has been filtered?
my formula seems to be counting all data in the range.
=COUNTIF(Q11:Q301,"249")

your help would be greatly appreciated