S
stevee22001
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!!
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!!