Try this:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(E4:E26,ROW(E4:E26)-ROW(E4),0,1)),--(E4:E26="aa"))

--
Biff
Microsoft Excel MVP


"stevee22001" wrote in message
...
Having difficulties using COUNTIF with filtered columns, column A not
really
relevant to this request, column B is either yes or no, column C & D are
not
relevant to this request either, column E is either aa, bb, cc or dd.

I am using =COUNTIF(E4:E26, "aa") to count the number of times aa appears,
this is getting me a figure, but when I filter column B to show with the
yes's or no's the figure doesn't change.

Thanks in advance for any help!!