How to find the sum of an entire column

like just in sharepoint? that should be pretty straight forward. 
 

Here is a list with a few values in a Number Column: 

Modify the view by going to the List tab and then by clicking the Modify View button:

Then scroll down to the ‘Totals’ area of the view properties dialog: 

Expand the Totals section and select “Sum” from the dropdowns for the Number column in question:

Don’t forget to SAVE:

The column’s sum is now displayed at the top of the column:

if it’s for a workflow then I don’t understand the question based off of the small screenshot you provided. Can you please give us more info / more screenshots of what you want or what you have now?

Alright, so you have Multiple Lists with a column called “Bucket Total”, and you want to gather all of the list items across both lists that share a common EmployeeID, and iterating over the items, need to add the Bucket Total value into a Total Points variable? does this describe the situation? 

Let’s say I have a list called Rules JS with the following items: 

Here is a workflow that will add all of the Bucket Total column values for a given EmployeeID into a variable called TotalPoints:

Let’s break it down. First we’ll start with the variables: 

For this example I am using a starting variable which will allow me to set the EmployeeID that I want to target.

The first action we’ll configure is Query List:

The CAML query is pretty straight forward. We’re looking at the Rules JS list, specifically where EmployeeID is equal to the value of the var_targetEmployeeID variable, and returning every value of the Bucket Total column into a Collection variable called var_BucketTotal_Collection. 

Here is the raw XML:

<Query>
  <Lists>
    <List Title="Rules JS" />
  </Lists>
  <ViewFields>
    <FieldRef Name="Bucket_x0020_Total" />
  </ViewFields>
  <Where>
    <Eq>
      <FieldRef Name="EmployeeID" />
      <Value Type="Text">{WorkflowVariable:var_targetEmployeeID}</Value>
    </Eq>
  </Where>
</Query>

I can confirm that this works by clicking the Run Now button and replacing the variable reference for var_targetEmployeeID with a known good value like “1”:

Which returns a collection of values as expected.

Now we need to setup our For Each Loop.

To do so is also straight forward. We’ll set the target collection to the var_BucketTotal_Collection variable as it contains all of the [Bucket Total] column values.

Next we’ll set the Store Results In to the var_BucketTotal variable, so that as we loop through the values, whichever value we’re on is stored in that variable.

Lastly we’ll set an Index to the var_Index variable even though this part is optional. I tend to do it any ways out of habit. 

The configured For Each loop should look like this:

Lastly we’ll setup a Math Operation inside of the loop:

Which will add whatever value is in the var_BucketTotal variable to the var_TotalPoints variables and save that resulting sum back into var_TotalPoints: 

Lastly I’ll send an email out to myself to see if it works:

Now let’s test it
 

The resulting email: 

Is it true?

it is!

 

Let’s try with EmployeeID 2:

Another success. 

Let’s try with an ID that doesn’t exist like EmployeeID 5:

It fails, but at least it doesn’t error out because it just creates an empty Collection and doesn’t do anything :)

Hope this helps to clear things up. 

The error you posted involves the Query List action, I would need to see how that’s configured before I could reasonably know what’s happening.

Please take a screenshot of the the Query List Settings and how its configured, feel free to block out any sensitive information like URLS or names, but do try to keep as much as possible 

Hi @Edmon 

Is your issue now solved?