+ Reply to Thread
Results 1 to 3 of 3

Ignore Row Based on Value?

  1. #1
    Registered User
    Join Date
    10-07-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Ignore Row Based on Value?

    Okay so here's what I have and I really hope someone can help me!

    cells.jpg

    I have three columns on this sheet that are of importance that contain these formulas:

    S113 calculates the total of the entire S range above: =SUM(S2:S111)
    S114 calculates the total of the S range AS LONG AS the G column has the word "booked in it: =SUMIF((G2:G111),"BOOKED",(S2:S111))
    S115 calculates the total of the S range AS LONG AS the G column has the word "un-booked" in it: =SUMIF((G2:G111),"UN-BOOKED",(S2:S111))

    The T column has the same formulas as above except the S is replaced with T in every formula.
    The U column is just the comparison between S113 and T113 (=(S113-T113)/T113), S114 and T114 (=(S114-T114)/T114), and S115 and T115 (=(S115-T115)/T115) in a percent format.

    What I need help with is this:
    If a row has the word NULL in column S or T, I need all of the forumlas at the bottom of S and T to completely ignore the valumes in that ENTIRE ROW. So as you can see from the picture above, T108 has the word "NULL" in it. What I would want is for all of S113, S114, and S115 to completely ignore any values in S (S108 for this example) since T has "NULL" in it. We are trying to get as accurate of a comparison as possible for this data and since there is no data for T108, it will not provide for an accurate comparison.

    Can anyone help me please?

  2. #2
    Registered User
    Join Date
    10-07-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Ignore Row Based on Value?

    I left off the labels, sorry! Cell S113 is the one with 2,953,398 as the value and the cell with NULL is T108.

    Sorry!

  3. #3
    Registered User
    Join Date
    10-07-2013
    Location
    Oldham, UK
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Ignore Row Based on Value?

    Try using an if statement in your U column, =if (iserror(s1)=false, if(iserror (t1)=false, sum ((s1-t1)/t1), 0))

    Dan
    Last edited by Danroyd; 10-07-2013 at 04:24 PM. Reason: missed a bracket

+ 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: 12
    Last Post: 07-04-2013, 07:26 AM
  2. how to ignore #VALUE!
    By fabian24 in forum Excel General
    Replies: 5
    Last Post: 10-01-2010, 04:03 PM
  3. IF to ignore #N/A
    By claytorm in forum Excel General
    Replies: 6
    Last Post: 11-21-2005, 03:53 PM
  4. [SOLVED] please ignore
    By Jordan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  5. please ignore
    By Jordan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

Tags for this Thread

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