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...
Hi wapiti59
You can try this
=COUNTIFS(Table1[Market],G4,Table1[RM Status],K4)
See the attached workbook. Note that I formatted the data as a table, hence the structured referencing. [Table is very useful as the formula automatically adjusts to include any new data subsequently, hence you may consider this]
I also typed in the criteria on both cells G4 and K4 to make it easier to change.
However, if you prefer not to use a table, the formula will be:
=COUNTIFS('CQ Opp View'!$G$10:$G$3191,G4,'CQ Opp View'!$K$10:$K$3191,K4)
Do let me know if you need additional clarification.
Cheers,