Formula - Add *Row* Rather Than *Column*?

daniel_atkins

Hi,

I'm looking for a way to add rows which contain formulas, where the Formula Tool only allows the addition of columns.

In the example, I have two types of formulas which need to be added:

1). A6 = A5 / A4 

2). A9 = A4 + A11 + A12

I'm hoping that this is a minor adjustment, as the entire workflow is already built out and working properly. I'm looking for something that can aggregate the final pieces of data without requiring a substantial portion of the workflow to be rebuilt.

Thank you!

Example.xlsx

ScottE

Hi @daniel_atkins 

Tough to say with the small sample and not knowing what else your workflow is doing. 

You could play around with the Multi-Row Formula to do math between rows but it won't do what you're asking by itself.

A better option might be to Crosstab your data into columns so you can use the Formula and then Transpose it back into rows.

-Scott