Hi
I was wondering if anyone can help... I need to use countif but be able to filter as well... this is my formula
COUNTIF(B$51:B$124,">"&B40)
I've tried...SUMPRODUCT(SUBTOTAL(3,OFFSET(b51,ROW(b51:b124)-ROW(b51),0)),--(b51:b124,">&b40")) but it won't work. What am I doing wrong?
Bookmarks