To Sum Numerical Data in Identical Property Rows

Click Insert tab Linking & Extraction panel Extract Data. Find
On the Refine Data page, click Combine Identical Rows.
Right-click the column label and choose Combine Record Mode Sum Values.
The sum of the numerical data is displayed.

Was this information helpful?

Yes
No