SUMIF,COUNTIF,VLOOKUP taking filtered data

[Sunny Jayadev]

Hi Chandoo,
While doing SUMIF or COUNTIF or VLOOKUP in a file after applying Filters to a data, it is also considering the hidden data.. How to make it to consider only the filtered data?

 

[Hui]

Sunny

Firstly, Welcome to the Chandoo.org Forums

Have a read of
http://chandoo.org/wp/about-hui/cha...-no-037-how-to-count-and-sum-filtered-tables/
Also read the comments as there are other suggestions there