How to get accurate row counts in partitions in a table
You need to ignore index_id with values that are not 0 (heap) or 1 (clustered index)

SELECT rows  FROM sys.partitions 
WHERE object_id = object_id('name of table') 
AND index_id &lt; 2