Correct syntax for a Calculated field in a Google sheets pivot table?

Question

Ive got 4 columns that i want to summerise as part of a calculated field in a pivot table.

In Sheet 1 i have the raw data and in Sheet 2 i have the pivot table.

For the calculated field i want to sum the values for the following columns named "Alpha", "Beta", "Charlie", "Delta". In this example the columns are L,M,N,Z.

To generate this calcualted feild value do this ive been trying the following ="Alpha"+"Beta"+"Charlie"+"Delta" and also =L+M+N+Z.

But they both through errors.

Im sure its something wrong with my syntax, but cant work out what.

Any ideas ?

Answer 1

This also worked for me:

=sum('Alpha', 'Beta', 'Charlie', 'Delta')

Good luck :)

Answer 2

You need to reference your columns with single-quote:

='Alpha'+'Beta'+'Charlie'+'Delta'

Google sheet pivot only allows column name from the source data to be used as reference in the calculated field or a direct cell reference, e.g. A1.

Answer 3

I believe in my testing it would be:

=sum(L,M,N,Z)

Answer 4

From this post, you can also use ArrayFormula. So you can do this simply:

=ArrayFormula(Alpha+Beta+Charlie+Delta)