Results 1 to 3 of 3

Averageif WILDCARD for website.com AND EXCLUDE website.com.xx

Threaded View

  1. 04-13-2014, 10:25 PM #1
    Gerhard.Angeles
    Gerhard.Angeles is offline
    Registered User
    Join Date
    05-02-2013
    Location
    QC
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Averageif WILDCARD for website.com AND EXCLUDE website.com.xx

    How do you do an averageif for pages with website.com BUT exclude all website.com.xx pages? I've tried using the formula
    Formula: copy to clipboard 
    =averageifs(range,criteriarange,"*"&website.com&"*",criteriarange,"<>"&website.com.xx)


    but to no avail.

    Help - Averageif.xlsx
    Last edited by Gerhard.Angeles; 04-13-2014 at 10:35 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. Thanks for this website!
    By mlogan in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-02-2013, 06:13 AM
  2. Opening website, getting data, closing website
    By beta_leonis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2012, 03:50 AM
  3. Problem when uploading to website
    By Drakath in forum Excel General
    Replies: 1
    Last Post: 07-26-2012, 11:25 AM
  4. HYPERLINK("website/"Cell.Text"website, A4)
    By keepstar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-17-2010, 05:17 PM
  5. Website XLS
    By jerryjaysr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2008, 09:38 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1