How can I get the number of rows in an Excel pivot table for use outside the pivot table?

I have a pivot table in Excel of the form:

Country Server Status
Australia AU1 1 AU2 1 AU3 4
New Zealand NZ1 4 NZ2 1
Germany DE1 1 DE2 4 DE3 1

I would like to add some summary information above the table showing the number of rows and the number of rows that match certain criteria, e.g.:

Number of servers: 8
Servers with status 4: 3

How can I count the rows in the pivot table, either in total or matching criteria? I have researched using the GETPIVOTDATA function but not found a solution (see ).

1 Answer

You can use a regular Count(), Counta() or Countif() functions.

B1 =COUNTA(B4:B2000)
B2 =COUNTIF(C4:C2000,4)