Count text entries in Pivot table

[kashaikh78]

Hi Guys,

Is there any formula to count the text entries in pivot table in excel 2007 apart from highlighting the cell?

[dilipandey]

Hi Kashaikh78,

You can use below function which is counting the text entries in range d1:d7 :-

Please Login or Register  to view this content.

enter formula using ctrl shift enter key combination. thanks.

Regards,
DILIPandey
<click on below * if this helps>

[kashaikh78]

Hi Dilipandey,

Thanks buddy...it worked

[dilipandey]

You are welcome Kashaikh78...

Please mark this thread as [SOLVED].. thanks.


Regards,
DILIPandey
<click on below * if this helps>