Results 1 to 3 of 3

SUM.IF: Sum and divide values in two different columns depending on the value to the left

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2014
    MS-Off Ver
    Excel 2010
    Posts
    12

    SUM.IF: Sum and divide values in two different columns depending on the value to the left

    Hello again!

    I've encountered one last problem before I can complete my work. In column C I have portfolio names, 1, 2 and 3 respectively. In columns E and F I have old stock price and new stock price, respectively. What I want to do is to divide the sum of the new stock price (F) with the sum of the old stock price (E) and take that sum minus one given that each cell value has the same cell value to the left (C). In cell F:120 to F:122 I then want these sums to be displayed, depending on which portfolio the return belongs to, with F:120 being portfolio 1, F:121 portfolio 2 and F:122 portfolio 3.

    I have a feeling it has something to do with a sum.if formula, but since i am quite bad at excel I have no idea how to proceed. Please see the attached worksheet as it will make much more sense.

    Grateful for any kind of help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. To add rows and columns depending on values in cell
    By kamps in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2013, 12:22 AM
  2. pasting values of columns depending on cell value
    By dirtydan86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2012, 11:07 AM
  3. Replies: 1
    Last Post: 02-16-2012, 09:18 AM
  4. Replies: 16
    Last Post: 01-11-2012, 10:51 AM
  5. Protect Rows depending on Values in Particular Columns
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2005, 09:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1