nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I sum the values in a field in ArcGIS Pro?

RoyceSimpson

I want to select a field in a table within ArcGIS Pro and get a quick look at the summation of all the values for all the selected records for that field. For example, I have a field called "acres". I want to select various features in the map, open the attribute table, show only the selected records, go to the "acres" field and see a summed up value for the acreage for those selected records.

Thanks for any help.

Find more posts tagged with

Accepted answers

rgmingo

All you need to do is open the chart properties pane

All comments

RoyceSimpson

In Arcmap, you could right click the field header, go to "statistics" and see the "sum". That functionality seems to be absent from Pro, but I'm hoping not.

I've been able to use the "summarize" gp tool but that creates a table every time I want to do this, which gets very cumbersome after a while.

TonyHowze

Hello Royce,

Have you figured how to sum a field in pro? I need to know because I can't stand creating unnecessary tables to do simple sums.

DanLee

Hi, here is a place where you can vote for the functionality:

https://community.esri.com/ideas/11923

RoyceSimpson

Voted.

SarahLarsen

Voted.

AndrewWallick3

It's crazy this functionality doesn't exist yet. I hope they add it soon.

ThomasColson

This was implemented in 2.1 (https://community.esri.com/ideas/11923 )

DanPatterson_Retired

And if you have multiple fields to do...

Statistics... Descriptive Statistics for multiple fields

JuliaBalakirova1

there does not seem to be a resolution yet. Is there? I am in 2.7 and I still get a table created with multiple records instead of just one fixed sum. Anybody else had a progress with this that you can share?

nkobel

Yeah this is very annoying. This thread talks about your question (you must right click your data in the TOC to create a histogram chart), but for me I can't get my selection to be differentiated from my dataset.

Map2021

Are you sure about that?

ErikTownsend

I dont see where that functionality was added either. You still have to create another statistics table in the map and I cant seem to get the area totals to go past 1 decimal point on the report. Perhaps this topic is too old as none of the links for votes or help are valid. Would appreciate it if anyone had a solution.

Time to open up Arcmap again I guess....

SamDearing

I found that when right clicking on the field, if I choose "statistics" instead of "calculate field," the chart properties pane will come up on the right side and show you multiple outputs, including the sum.

rgmingo

All you need to do is open the chart properties pane

jdag03

Yes! Thank you!

GeorgeBrown1

Have tried about everything within this thread and still unable to get a Sum (total population of Census blocks within a specific police zone). After about an hour of trying suggestions, I ended up just using the Edit In Excel option from a right click on that census block selection and in seconds I had the total 2020 population.

Not sure why this is not possible in AGP??

GordondeSouza

Have you found a solution to getting more than 1 decimal place on the statistics report?

BrendanQuirk

I just upgraded to 3.0 and when I clicked statistics to get a chart, the chart properties window looks different now and I can't just see the "sum of selected features" like I used to. It is extremely useful! Anybody know how to access that in 3.0?

DamonHess

Right click on the field in the Attribute Table and select Statistics. It will open a chart. The Chart Properties pane should open on the right, and Sum is one of the calculated values. If the Chart Properties pane does not open, click on the Properties button on the top left of the chart.

MeganHicks

It doesn't seem to be possible to get the statistics for shape area, unfortunately. Seems like a pretty big oversight, and I hope that gets added to the functionality.

LisaMcAleer

Seriously, for the SHAPE.STArea() field, the Statistics for the entire Dataset and the Selection are identical. It does not give Statistics for the Selection. It's like that in 3.0.1 and in 3.1.1. The only way to get Statistics of selected records is to use the geoprocessing tool? Or desktop. Not sure what the prob is, but it needs to be fixed.

Capture517.PNG

Bart-JanSchoenmakers

I have the same problem, it doesn't show the difference between the selection and all records. This is a really annoying problem. Only solution is to create a table to get the total, or use ArcMap. I opened a support issue with my local ESRI office.

Update from ESRI:

- This is confirmed as bug

KimMamaradlo

Perfect! Thank you!

MeganHicks

For everyone who has been frustrated by this (like me), use the data engineering tools instead of right-click/Statistics from the attribute table like you would in ArcMap.

When you have your features selected, right-click the layer in the table of contents, and choose Data Engineering. Then drag the field you're interested in into the box. This method will give you the accurate sum of shape area.

AprilJohnson2

This is great but still doesn't work with lengths and areas. I can't believe ESRI missed this! Please fix ESRI. 😉

KatyRediferDenver

This works! Thank YOU!

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.