[PLUG-applications] OOo formula questions

[der.hans]

moin moin,

I have a couple of questions on how to do a couple things in the
spreadsheet.

I would like to add up the numbers in column B if column A has a
particular value.

In the end, I'd like to do this for two different cases, but one might
just be a form of the other.

anke:10
anke:20
fred:10
fred:50
anke:2112
fred:0
anke:-15
georg:2112
georg:42

I'd like a formula that would give me the total of cells in column B where
the column A cell for that row has the value of anke.

I'd also like to do running totals for each unique entry in column A. In
this particular case I'd dynamically get 3 cells as there are 3 unique
entries in column A. In each of those cells would be the total for that
person. In the end I probably need 6 cells as I also need to know who each
total belongs to.

anke:$total_for_anke
fred:$total_for_fred
georg:$total_for_georg

Column A isn't necessarily a string and might instead be numbers. I want
the spreadsheet sorted on another column that isn't related.

For another issue I'd like to see if column A really is the result of
somehow combining other cells. I'd like to either turn the cell in column
A red or another cell red if the numbers don't match.

Let's say the relationship is subtracting column C from column B.

2112:2154:42:GREEN
2112:42:2154:RED
0:2112:42:RED
2112:2112:0:GREEN

Something like that.

ciao,

der.hans
-- 
#  http://www.LuftHans.com/        http://www.LuftHans.com/Classes/
#  I only eat free-range vegetables that were hunted down and slain by
#  a member of my immediate family.  -- der.hans