[PLUG-applications] OOo formula questions

[Emunds A. Rolley]

Hans,
Here is a partial solution using the example.
Bud Rolley
 
On Mon, 2 Feb 2009 19:14:09 -0700 (MST) "der.hans"
<PLUG-Anwendungen at LuftHans.com> writes:
> 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
> _______________________________________________
> PLUG-applications mailing list
> PLUG-applications at lists.PLUG.phoenix.az.us
> plications
> 
> Reminder: All replies will go back to this mailing list. If you wish 
> to send a reply to a specific person, please use the reply function 
> and change the &quot;To:&quot; address to that person before 
> sending.
> 
> 
 
____________________________________________________________
Click to learn about options trading and get the latest information.
http://thirdpartyoffers.juno.com/TGL2141/fc/PnY6rw2SBF4rWqe4y7Ll7THzK0tlDtqh3IC1CqtCGgf5b80u8hlrd/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/msword
Size: 27136 bytes
Desc: not available
Url : http://lists.plug.phoenix.az.us/pipermail/plug-applications/attachments/20090203/7c285c38/attachment.wiz