Results 1 to 7 of 7

SUMIF?? for combination text-numeric greater than a certain number

Threaded View

  1. 06-25-2014, 11:51 AM #1
    sam887
    sam887 is offline
    Registered User
    Join Date
    06-25-2014
    Location
    New York, NY
    MS-Off Ver
    Office for Mac 2011
    Posts
    5

    SUMIF?? for combination text-numeric greater than a certain number

    I am trying to figure out how to sum visits for various browser sizes. The browser sizes are displayed in a combination of text and number (eg, 600x1200). I want to count any visits with a screen size above 1000 (either height or width). Anyone know how to do this?

    See attached.
    Attached Images Attached Images
    Last edited by sam887; 06-25-2014 at 12:00 PM.
    Reply With QuoteRegister To Reply
« 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. Sumif is working for numeric values but can we do the same for text?
    By vinsocf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2014, 02:59 PM
  2. Sumif is working for numeric values but can we do the same for text?
    By vinsocf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2014, 08:35 AM
  3. Excel 2010 formatting to use letter and number combination / alpha-numeric
    By Howie707 in forum Excel General
    Replies: 12
    Last Post: 12-13-2013, 04:29 PM
  4. [SOLVED] Sorting a combination text/numeric value
    By JimDandy in forum Excel General
    Replies: 4
    Last Post: 10-02-2013, 12:48 PM
  5. [SOLVED] HOW DO YOU SUMIF THE NUMBER IS GREATER THAN BUT LESS THAN A #
    By uma in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2005, 02:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1