count pivotitems

  1. B

    Count cells in a Pivot

    Hi, I am looking for a formula to count cells that are not empty in a pivot. The complication is that it needs to count cells/rows across multiple columns. My query would be something like the following: If anything in rows 2 to 30 in the columns D,J, and K, put "1" in this cell. I will then...
    • b19upj
    • Thread
    • columns count count cell count pivotitems pivot
    • Replies: 1
    • Forum: Excel Questions
  2. C

    VBA Count Visible Pivot Items

    I have a pivot table that shows usernames and a count of how many times each username appears in my data. The pivot table also has a filter field which filters the data by course title. I have set the filter so that the pivot table only displays data for 1 specific course. This gives a list of...
    • CarolynS
    • Thread
    • count pivotitems excel 2007 pivotitems pivottable vba
    • Replies: 1
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top