Results 1 to 5 of 5

Which functions to use?

Threaded View

  1. 10-09-2014, 09:31 PM #3
    Dgholaml
    Dgholaml is offline
    Registered User
    Join Date
    10-09-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    3

    Re: Which functions to use?

    Ok I tried =COUNTIF(C$5:C$18,INDIRECT(F5)) but I get 0. What's the correct way of nesting the INDIRECT function?

    Also tried =COUNTIF(INDIRECT(GALAXYtype),"Comedy")
    Last edited by Dgholaml; 10-09-2014 at 09:37 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. Excel 2007 : Calling functions based on input values in Excel 07 (functions array?)
    By duby13 in forum Excel General
    Replies: 1
    Last Post: 02-10-2012, 05:27 PM
  2. AddIn With custom functions - Functions not working in Excel2010
    By brum17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2011, 08:25 AM
  3. AVERAGEIFS, SUMIFS and COUNTIFS Functions New functions in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-15-2007, 05:24 AM
  4. efficiency: database functions vs. math functions vs. array formula
    By nickname in forum Excel General
    Replies: 2
    Last Post: 07-13-2006, 11:30 PM
  5. [SOLVED] Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions
    By sujay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2006, 05:20 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