Results 1 to 2 of 2

Thread: looking for Office MS similar sum feature

  1. #1
    Join Date
    Oct 2007
    Beans
    Hidden!

    looking for Office MS similar sum feature

    looking for a tool that adds all the numbers that are highlighted in a row. Open Office doesnt do this well. for ubu. any ideas??

  2. #2
    Join Date
    Oct 2007
    Beans
    1,914
    Distro
    Lubuntu 12.10 Quantal Quetzal

    Talking Re: looking for Office MS similar sum feature

    Don't Know of any. Maybe you can create an extra row in which you add the information if the cell above is selected or not and use the SUMIF function?

    In OpenOffice, for example, you type the number into the cells A1...E1 and the information whether the cells are selected or not into A2...E2. Then you can use the formula "=SUMIF(A2:E2;">" & 0;A1:E1)" to get the conditional sum as requested.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •