SOLVED

Number of rows displayed in pivoted table.

%3CLINGO-SUB%20id%3D%22lingo-sub-1504574%22%20slang%3D%22en-US%22%3ENumber%20of%20rows%20displayed%20in%20pivoted%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504574%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20seem%20to%20figure%20out%20how%20to%20know%20the%20number%20of%20rows%20in%20a%20pivot%20table%2C%20is%20there%20a%20formula%20for%20it%20or%20where%20to%20look%20on%20the%20table%3F%20Can%20someone%20please%20help%20me%20out%3F%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1504574%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

I don't seem to figure out how to know the number of rows in a pivot table, is there a formula for it or where to look on the table? Can someone please help me out? Thanks.

4 Replies
Highlighted

@steveo69 can you please explain in detail what you actually need with some photo attached

Highlighted
Best Response confirmed by steveo69 (New Contributor)
Solution

Hi @steveo69 

 

If i understand you correctly you need to count the row in the pivot table, you need to change the value to instead of sum to count in the value area or select the sum column > right click > summarized values by > count

 

Snag_1f664388.png

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

Highlighted
Thanks Faraz, I'm indeed very grateful. U understood my question and your explanation is accurate and clear.
Thanks once more. I will appreciate if I can be able to contact u more if I need help on excel because I'm just beginning my journey on it.
Highlighted

Hi @steveo69 

 

Feel free to post your query & sure you can reach me along with many other experts on Tech Community to support you

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more