+ Reply to Thread
Results 1 to 3 of 3

Not sure what formula use...help needed...thank you

  1. 05-16-2014, 11:01 AM #1
    MrsDowFire
    MrsDowFire is offline
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    Not sure what formula use...help needed...thank you

    I'm trying to add only the cells in Column G that have an "X" in Column H.

    Can someone help me do this? Thank you.

    I've inserted an example.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-16-2014, 11:05 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,139

    Re: Not sure what formula use...help needed...thank you

    Hi there.

    This should do what you want.

    =sumifs(g:g,h:h,"x")
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 05-16-2014, 11:07 AM #3
    MrsDowFire
    MrsDowFire is offline
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Not sure what formula use...help needed...thank you

    Thank you so much! I tried the sumifs but got confused when trying to work in column h into the formula.
    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. Formula Help Needed - Problem having part of formula reference the correct cells
    By Paton27 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-03-2013, 06:25 PM
  2. Index - Match Formula help needed OR Most likely an entirely new formula.... HELP!
    By tstowe in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-19-2012, 08:48 PM
  3. [SOLVED] index formula needed--how to get a formula to skip columns
    By rsmidtisu in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-02-2012, 11:22 AM
  4. IFTHEN formula? Formula needed to suggest existing salary range
    By starrynight in forum Excel General
    Replies: 3
    Last Post: 09-07-2012, 12:07 AM
  5. Help Needed With Formula
    By skate1991 in forum Excel General
    Replies: 5
    Last Post: 11-23-2011, 08: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