Forum Discussion

Copper Contributor

May 15, 2020

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

excel

Formulas and Functions

Abiola1

MVP

May 15, 2020

You can attach your file for better understanding of how your data is structured

wapiti59

Copper Contributor

May 15, 2020

Abiola1Specifically, you will see what I am trying to do at the bottom of the CQ Opp View Tab. If I can get one formula to handle cell E3195, then I should be able to adapt it to the other criteria. Thank you!

Key Deals and Roadmaps.WW.Sec.Services.20.5.13.xlsx3.6 MB