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

stevee22001;221134 Wrote:
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!!

Hi,Have a go at the SUBTOTAL function
'This link' (http://www.contextures.com/xlFunctions01.html#Filter) will
help


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60919