Results 1 to 7 of 7

SUM(If a cell contains a certain word, then return the value of that cell (another cell))

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    Spain
    MS-Off Ver
    Excel 2007
    Posts
    34

    SUM(If a cell contains a certain word, then return the value of that cell (another cell))

    I did a search and could not find the solution, so there it goes:

    I have a table with nine funds (c4:c12) and a style for each fund (D4:D12), I want a formula in C17 that will sum the weight of each fund (b4:b12) if d4=Balanced, d5=Balanced, d6=Balanced and so on.

    Can I do this? I tried with =SUM(IF(D4:D12=''Balanced'';B4:B12;'''') but it gave back an error.

    Can you help me?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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