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