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