+ Reply to Thread
Results 1 to 3 of 3

Summing cells with the same preceding cell value

  1. 05-23-2015, 02:48 AM #1
    yugo23
    yugo23 is offline
    Registered User
    Join Date
    05-23-2015
    Location
    Serbia
    MS-Off Ver
    2007
    Posts
    12

    Summing cells with the same preceding cell value

    I need help with summing cells that have the same cell value to the left. In my example, I need all wood quantities summed, all metal quantities summed etc.

    Any ideas?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-23-2015, 02:51 AM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Summing cells with the same preceding cell value

    Use SUMIF

    =SUMIF(B:F,"Metal",C:G)

    You can also use a cell reference instead of the text "Metal"
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 05-23-2015, 04:39 AM #3
    yugo23
    yugo23 is offline
    Registered User
    Join Date
    05-23-2015
    Location
    Serbia
    MS-Off Ver
    2007
    Posts
    12

    Re: Summing cells with the same preceding cell value

    I am getting the idea, but when I enter that formula in a cell nothing happens. All cells are formatted as 'General'. When I type the formula, instead of pasting it, I get 'This formula contains an error' message.
    Last edited by yugo23; 05-23-2015 at 05:24 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional format cells in column, RAG, based on preceding cell value
    By Smudge.Smith in forum Excel General
    Replies: 8
    Last Post: 11-08-2013, 05:21 AM
  2. [SOLVED] Formula to insert text in new column if preceding more than one of the preceding have val
    By aimeecrystalaid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-04-2013, 11:47 PM
  3. how to find first blank cell in column then copy all preceding cells
    By an0593 in forum Excel General
    Replies: 7
    Last Post: 08-14-2013, 05:41 AM
  4. If preceding cell in a column is blank, block input in current cell.
    By Bachi in forum Excel General
    Replies: 9
    Last Post: 12-09-2011, 04:39 AM
  5. My formula cell has stopped adding the preceding cells.
    By Miriam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-02-2006, 10:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1