Sum a Range/Series of Rows

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!

Datasets

Help

Accepted answers

DataNath

@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:

Sum by colour.yxmd

All comments

Example attached:

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.

Sum a Range.yxmd

Qiu

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

My solution.

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335