ExcelBanter - COUNTIF with pivot table results?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - COUNTIF with pivot table results? (https://www.excelbanter.com/excel-worksheet-functions/108944-countif-pivot-table-results.html)

[email protected]

COUNTIF with pivot table results?

Is there a way to use COUNTIF (or similar function) on just the VISIBLE
results from a pivot table? It seems to be counting everything in the
table even when it hides non-selected rows.

Thanks.

John

All times are GMT +1. The time now is 01:54 PM.