Results 1 to 12 of 12

SUM/INDEX/LEN with date

Threaded View

jimbosi SUM/INDEX/LEN with date 02-25-2014, 04:47 PM
XOR LX Re: SUM/INDEX/LEN with date 02-25-2014, 04:56 PM
jimbosi Re: SUM/INDEX/LEN with date 02-25-2014, 05:07 PM
XOR LX Re: SUM/INDEX/LEN with date 02-25-2014, 05:16 PM
jimbosi Re: SUM/INDEX/LEN with date 02-25-2014, 05:46 PM
XOR LX Re: SUM/INDEX/LEN with date 02-25-2014, 05:49 PM
jimbosi Re: SUM/INDEX/LEN with date 02-25-2014, 05:51 PM
XOR LX Re: SUM/INDEX/LEN with date 02-25-2014, 06:00 PM
jimbosi Re: SUM/INDEX/LEN with date 02-25-2014, 06:31 PM
XOR LX Re: SUM/INDEX/LEN with date 02-25-2014, 06:37 PM
jimbosi Re: SUM/INDEX/LEN with date 02-25-2014, 06:50 PM
XOR LX Re: SUM/INDEX/LEN with date 02-25-2014, 06:52 PM
  1. #1
    Registered User
    Join Date
    11-23-2013
    Location
    Washington DC
    MS-Off Ver
    Excel 2010
    Posts
    69

    SUM/INDEX/LEN with date

    Hello everyone,

    I'm using the following formula to extract a count of multiple values in a cell:

    =SUM(INDEX((LEN($A$1:$A$100)-LEN(SUBSTITUTE($A$1:$A$100,H2,"")))/LEN(H2),0,0))

    I need to add a portion to the formula that looks for a date range in E:E (which are formatted MM-DDD-YYYY), specifically month to month. I'm not sure if a date criterion should go at the end of the formula, or in it. I'm used to using COUNTIFS, which are simple by comparison. I'm still learning more complicated functions, so apologies for submitting a question that probably has an easy answer (that I haven't found yet).
    Last edited by jimbosi; 02-25-2014 at 04:53 PM. Reason: increased clarity.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Index Match Based on One Date Criteria, Table Contains Beginning Date and End Date
    By jcox1953 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2014, 02:41 PM
  2. [SOLVED] INDEX date that MATCH on date range, MATCH code(string)
    By Dahlia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2014, 03:33 AM
  3. [SOLVED] Row Index on a Date
    By kristy.brown in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2013, 06:13 PM
  4. index or sumproduct for date
    By jw01 in forum Excel General
    Replies: 2
    Last Post: 11-30-2012, 03:01 AM
  5. [SOLVED] Index Match to date
    By jimtoyz in forum Excel General
    Replies: 4
    Last Post: 08-28-2012, 10:32 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