+ Reply to Thread
Results 1 to 2 of 2

Formula for column T = 'Yes', then column U should = 'P'

  1. 09-17-2013, 06:45 PM #1
    vanrudi
    vanrudi is offline
    Registered User
    Join Date
    09-17-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2011 MAC
    Posts
    1

    Formula for column T = 'Yes', then column U should = 'P'

    Hi,

    In Column U, I need a formula that Reads Column T. If Column T states 'Yes', then Column U needs to display the value in cell 'P'.
    Reply With QuoteRegister To Reply
  2. 09-17-2013, 06:52 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUM IF Help

    Not real clear. Here's my best guess...

    This formula entered in U2:

    =IF(T2="Yes",P2,"")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    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. Excel 2007 : Resolving ties in rank formula (tie in original column + tie in 2nd column)
    By CRIMEDOG in forum Excel General
    Replies: 3
    Last Post: 08-02-2013, 02:16 PM
  2. Formula that compares the column labels of two pivot tables and divides the column total
    By Jeep56 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2013, 02:35 AM
  3. Formula/macro to edit cells in one column based on contents of a cell in another column
    By robbyvegas in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-25-2012, 06:10 AM
  4. What formula to use?:Sum column W if column Q equals 390 & column L equal McL
    By Carolyn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-04-2006, 03:00 PM
  5. what formula do i put for column m = column k minus column l in e.
    By jenniss in forum Excel General
    Replies: 5
    Last Post: 01-06-2005, 05: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1