Results 1 to 21 of 21

Countif Specific issue

Threaded View

  1. #1
    Registered User
    Join Date
    12-02-2017
    Location
    NJ
    MS-Off Ver
    2016
    Posts
    27

    Countif Specific issue

    Hello. I'm trying to figure out a formula to pull very specific info from a large raw data spread sheet

    I need to calculate the number of Account ID (colum a) that appear in the list 1 time but also have the charge date (colum G) of 11/1/2017. Oh and have a $ amount above $100 in Colum J.

    I have tried several ways its simply beyond my ability. Any help would be great.

    Data Range
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    1
    Account ID
    Group
    Period
    Freq
    Category
    Disp Code
    Charge Date
    Due Date
    Amount Paid
    Amount Unpaid
    Total Amount
    2
    258101000001
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $0.00
    $718.78
    $718.78
    3
    258101000004
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $136.00
    $38.78
    $174.78
    4
    258101000034
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $60.17
    $658.61
    $718.78
    5
    258101000035
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $130.17
    $588.61
    $718.78
    6
    258101000058
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $60.17
    $658.61
    $718.78
    7
    258101000062
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $60.17
    $658.61
    $718.78
    8
    258101000065
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $0.00
    $638.95
    $638.95
    9
    258101000065
    258
    Nov-16
    A
    MF
    A
    9/30/2017
    11/1/2016
    $0.00
    $620.35
    $620.35
    10
    258101000065
    258
    Nov-15
    A
    MF
    A
    9/30/2017
    11/1/2015
    $53.48
    $537.32
    $590.80
    11
    258101000087
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $60.17
    $658.61
    $718.78
    12
    258101000089
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $95.17
    $623.61
    $718.78
    13
    258101000093
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $60.17
    $658.61
    $718.78
    14
    258101000108
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $60.17
    $658.61
    $718.78
    15
    258101000109
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $165.17
    $553.61
    $718.78
    16
    258101000116
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $0.00
    $862.52
    $862.52
    17
    258101000116
    258
    Nov-16
    A
    MF
    A
    9/30/2017
    11/1/2016
    $0.00
    $837.40
    $837.40
    18
    258101000116
    258
    Nov-15
    A
    MF
    A
    9/30/2017
    11/1/2015
    $37.20
    $760.32
    $797.52
    19
    258101000116
    258
    Nov-05
    A
    MF
    A
    9/30/2017
    11/1/2005
    $70.00
    $0.00
    $70.00
    20
    258101000118
    258
    Nov-17
    A
    MF
    A
    9/30/2017
    11/1/2017
    $53.48
    $665.30
    $718.78
    Last edited by JBeaucaire; 12-04-2017 at 11:45 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Countif issue
    By businpro in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-30-2017, 10:58 PM
  2. COUNTIF Issue
    By [email protected] in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-26-2016, 04:13 AM
  3. Could someone please help with this CountIF issue
    By Lacer75 in forum Excel General
    Replies: 6
    Last Post: 12-09-2014, 05:31 PM
  4. [SOLVED] Very Specific Sorting Issue Using COUNTIF
    By ATLGator in forum Excel General
    Replies: 5
    Last Post: 05-17-2012, 03:47 PM
  5. COUNTIF issue
    By JO505 in forum Excel General
    Replies: 4
    Last Post: 05-29-2011, 09:13 PM
  6. CountIF issue
    By edmdas in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-03-2007, 11:48 AM
  7. [SOLVED] issue with countif in vba
    By Xavier Minet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1