I have looked for this answer but have not found it.

I want to.....Count all widgets when account info ="".

I have 8,000 inventory records. I only want them counted in the pivot
table when it has not been sold or is not currently being rented.



Can I do this in a pivot table?

Many thanks,

Steve