+ Reply to Thread
Results 1 to 4 of 4

Create formula to sum column total if specific text is present in second column

  1. #1
    Registered User
    Join Date
    08-08-2013
    Location
    Brighton, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Create formula to sum column total if specific text is present in second column

    Sample Workbook.xlsx

    I'm trying to sum the totals of a column (column I and column J) if a second column (column G and column H) has the text "Y" in it but to not add in if the row cell is blank of the relevant columns. Can anyone advise on the formula. The figures of the column required to be totalled are equal to value of previous cells so are calculated by a cell formula in that column cell.
    I hope I'm explaining myself well here.
    The sample workbook attached is a short representation of what I'm trying to do, thank you for all help suggested, cheers.

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Create formula to sum column total if specific text is present in second column

    Hi
    If I understand you correctly put this formula in G15:

    =SUMIF(G3:G14,"Y",F3:F14)

    and this formula in H16:

    =SUMIF(H3:H14,"Y",F3:F14)

    Good luck.
    Tony

  3. #3
    Registered User
    Join Date
    08-08-2013
    Location
    Brighton, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Create formula to sum column total if specific text is present in second column

    Cheers Tony, that does nicely. I'm still a beginner with Excel but have always wanted to master the formulas a bit better. This short string is perfect and opens up a few other possibilities for me going forward. Thanks a lot

  4. #4
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Create formula to sum column total if specific text is present in second column

    Happy to help. Thanks for the feedback.

+ 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. Formula to calculate total from column with text
    By Sadalif in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2013, 01:52 PM
  2. [SOLVED] Merge/unmerge based on whether specific text is present in a column
    By susanbarbour in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2012, 09:08 AM
  3. Formula to display whether a text data is present or not in a column
    By shuresh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2009, 03:42 AM
  4. SUM/COUNT column(s) based on specific value present within the column
    By markx in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-22-2005, 07:06 AM
  5. Replies: 2
    Last Post: 02-13-2005, 07:06 PM

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