Maybe

=SUMPRODUCT(--(F7:F1001<0),--SUBTOTAL(3,OFFSET(F$6,ROW(F7:F1001)-ROW(F6),,1)))


Regards,


Peo Sjoblom


"JavyD" wrote in message
...
Can this be done, I already have the formula to provide me a count on text
when a column is filtered, the bad thing is that I need it to not count a
cell if it's a Zero. This is the formula I have

=SUMPRODUCT((SUBTOTAL(3,OFFSET(F$6,ROW(F7:F1001)-ROW(F6),,1))))

Now, on that range F7:F1001, The label is March, I need to analyze
inventory
turns by company on an item, so If I filter the company to say Dell, I
want
to see the items and how many turns as a total we had in March, but it's
counting Zeros too. Can this be done?