# Complex Formula - How to access other cells' data in a formula

Hello,

I'm trying to create a formula to classify some registers to A,B or C depending in a total value percentaje.

**A = de 0 a 80**

**B = 80,01 a 90**

**C = 90,01 a 100**

Example:

Name Value % %Sum **Class**

A 2000000 38% 38% **A**

B 1500000 28% 66% **A**

C 1000000 19% 85% **B**

D 800000 15% 100% **C**

Sum 5300000 100%

In web intelligence I can get to,

Name = (Name)

Value($) = (Value)

%s/total =Percentage((Value))

%Sum ?

**Class** ?

The way to calculate the %Acum is first to sort all the registers by rank and then you can calculate A, A*B, A*B*C, A*B*C*D (this can be done in Excel), but I don't know how you can access other cells' values from a single cell.

If I can do that, then I can do an if() formula that filter %Sum by a range (if(%Sum>90;"C";if(%Sum<80;"B";"C")). My problem is how can I calculate the column %Acum

Thanks & Regards

SU

Edited by: soauniverse on May 24, 2011 10:42 PM

##### Rohit Gupta replied

Use **RunningSum([Object])** function to get the cumulative sum.

Regards,

Rohit