I have entries like T, 0.5T, 0.4P, 1P and so on in a spreadsheet. I want to add the similar items ie., I want to be able to add (T + 0.5T) (0.4P + 1P) and compute the total ie., 1.5T, 1.4P
built-in SUM() accepts only integers. Is there a way to add algebraically in Openoffice ? Even if a solution exists in GNumeric or MS Excel it is fine. I am looking for a solution without having to write any VBScript or equivalent.
Just for information, the Ts and Ps above indicate the Project types and FTEs assigned to the Projects. This addition would help me total the resource allocation per project type.