Sum a Range/Series of Rows

[knorr]

Hi, 

I'm looking to calculate the Sum of each Color across Jan through Mar. My actual dataset includes 30+ columns/data fields so I am looking for a solution that does not involve adding each field in a Multi-Row Formula (i.e. Jan + Feb + Mar... etc).

	Jan	Feb	Mar
Red	11	12	7.5
Orange	10	13.01	9
Yellow	14.4	5	2
Green	8	2	1.11

Thank you!

[DataNath · Accepted solution]

@knorr are you wanting to sum all fields? You can transpose the data, selecting colour as a Key Column. Afterwards, you could use a Summarize tool to then Group by Colour and Sum the values. If you need this sun added to the original data set then you can just use a Join tool, with Colour as the join field.

Example attached:

[Emmanuel_G]

@knorr 

Find in attachement the way of doing this.

Note that even if you have many fields, It is enough that the box Dynamic or Unknown Columns is checked in transpose tool so that all your columns (apart from those which have been taken into account in key columns ) are mapped into data columns and therefore transposed.

Please do not hesitate to mark this answer as solution if it helped.

             

[Qiu]

@knorr 
The Cross Tab tool has the additon functions for Mothod of Agrregating values.
We can use the Total Colum in your case.

[Sarreddy]

My solution.

[knorr]

Thank you all! I went with a transpose -> Sum -> Join.