Results 1 to 4 of 4

Please Help, need a formula to count cells based on dates in 2 other cells matching.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Please Help, need a formula to count cells based on dates in 2 other cells matching.

    WS attached-Please help
    There Are 3 headings on both sheets named “LEAD” and “LG” that are the same and
    where the following info will need to go; headings are “APPT”, “TAKEN” and “SOLD”.

    When any date is entered into “LEADS” H6:H1005, that date will be counted as “1” and entered
    Into “LG” I22:I1021 only when the dates from “LG” B22:B1021 and “LEADS” B6:B1005 match exactly.

    I need the same formula for the adjacent headings on the “LEADS” sheet under TAKEN and SOLD.

    Thank you
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count data based on matching dates in 2 separate cells.
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-16-2017, 12:11 PM
  2. [SOLVED] Count a range of cells based on dates in other cells
    By petelomax in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-25-2014, 11:43 AM
  3. [SOLVED] Count cells containing Dates (greater than 2014) based on Filtered Cells
    By sam99 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-26-2014, 10:30 AM
  4. [SOLVED] Array formula to count cells matching various texts
    By pdanes in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-17-2014, 12:46 PM
  5. [SOLVED] Formula to count based on dates and text in multiple cells - See Spreadsheet
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-16-2013, 11:40 AM
  6. [SOLVED] Formula Needed to count a range of cells based on criteria in 2 other cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-01-2013, 04:06 PM
  7. [SOLVED] Formula to count cells between dates.
    By Vegs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2006, 02:00 PM

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