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
yess or nos the figure doesnt change.

Thanks in advance for any help!!