+ Reply to Thread
Results 1 to 4 of 4

Add only the cells in one column when the value in another column is specific

  1. #1
    Registered User
    Join Date
    01-04-2015
    Location
    Beaufort, NC
    MS-Off Ver
    Microsoft office 2011 for Mac
    Posts
    9

    Add only the cells in one column when the value in another column is specific

    If I have a column labeled Description (say Column B) and another labeled Expenses (Column E) in which the cost of the expense is contained, is there a way to tally only those numbers in Column E when the entry in Column B is something very specific, such as "brooms"?

    E.G.:

    Date Description Cost
    1/1/15 dust pans 15.00
    2/1/15 mops 45.00
    3/1/15 mops 45.00
    4/1/15 dust pans 15.00

    In another field I want to total the cost of mops only, which would show the total cost to be $90. Is there a way to do that or must the table be laid out by individual types of expenses in their own column or row?

  2. #2
    Forum Contributor
    Join Date
    06-21-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: Add only the cells in one column when the value in another column is specific

    =sumif(b1:b100,"brooms",e1:e100)

  3. #3
    Registered User
    Join Date
    01-04-2015
    Location
    Beaufort, NC
    MS-Off Ver
    Microsoft office 2011 for Mac
    Posts
    9

    Re: Add only the cells in one column when the value in another column is specific

    Wow. Worked perfectly! (After changing the text, of course.) I'll never be able to remember that and can't imagine how anyone would come to know it. I really didn't expect that question to have an answer that suited what I wanted to do perfectly. Thanks b1*b2 when b2 =or> 1000!

  4. #4
    Registered User
    Join Date
    01-04-2015
    Location
    Beaufort, NC
    MS-Off Ver
    Microsoft office 2011 for Mac
    Posts
    9

    Re: Add only the cells in one column when the value in another column is specific

    Wow. Worked perfectly! (After changing the text, of course.) I'll never be able to remember that and can't imagine how anyone would come to know it. I really didn't expect that question to have an answer that suited what I wanted to do perfectly. Thanks b1*b2 times when b2 =or> 1000!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 10-26-2014, 06:01 PM
  2. Replies: 2
    Last Post: 04-17-2014, 03:30 PM
  3. shift cells in column 2 spaces to right if specific text appears in that column
    By hosburgh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2014, 12:46 PM
  4. Fill cells in one column based on specific words or letter from another column
    By dokkadokka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2013, 07:04 AM
  5. Replies: 4
    Last Post: 04-25-2013, 03:53 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