Results 1 to 3 of 3

Count based on letter designations and dates

Threaded View

  1. #1
    Registered User
    Join Date
    12-02-2006
    Posts
    51

    Count based on letter designations and dates

    On the attached example have two worksheets within one file, MASTER and INFO.

    In INFO-B3, I need to count the number of times that MASTER-column [I] shows a value under 10000, MASTER-column [H] shows dates in 2006, MASTER-column [K] shows the letter "A".

    In INFO-B4, I need to count the same information with the exception of MASTER-column [I] showing values between 10000-24999. The same for B5 and B6, with B6 showing values over 50000.

    THEN, I need INFO-B11 thru B14 to show the same information but only when "AJB" appears in MASTER-column [G]

    Thank you very much for your help. You folks are amazing.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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