Forum Discussion
Counting visible rows in a filter set that meet specific criterea in two columns
I have a worksheet containing data that has sales pipeline information in it for the entire company whose data set includes rows 10-3153. I have applied a filter in one of the columns to narrow down...
You may add helper column let say Y) with formula
=AGGREGATE(3,5,A9)drag it down till the end of the range. Formula returns 1 for visible rows and zero for hided ones.
With that counting could be as
=COUNTIFS($G$10:$G$2538,$A2542,$K$10:$K$2538,"Won",$Y$10:$Y$2538,1)