+ Reply to Thread
Results 1 to 3 of 3

Formula Needed to count sales on one sheet based on data in multiple cells on another

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

    Formula Needed to count sales on one sheet based on data in multiple cells on another

    The same formula is needed for 3 sets of columns on sheet ‘STATS’

    Sheet ‘STATS’ C21:C32 & D21:D32 are under the heading in C19 as APPT
    Those 2 columns and the adjacent TAKEN & SOLD heading columns are the ones where the formula will need to populate.

    So to cover how the formula needs to work, let me give an example:
    From the ‘LEADS’ sheet, when a date is entered into J6:J1005 which falls under the APPT heading, a count should populate in ‘STATS’ C21:C32 or D21:D32 based on the input on ‘LEADS’ I6:I1005 and the date entered to fall under the correct month.

    The same is needed for the TAKEN header on STATS F21:F32 & G21:G32
    As well as SOLD header on STATS I21:I32 & K21:K32

    This would be a big help
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,918

    Re: Formula Needed to count sales on one sheet based on data in multiple cells on another

    Named Ranges:
    APPT =LEADS!$J$6:$J$1005
    BorS =LEADS!$I$6:$I$1005
    LeadDates =LEADS!$J$6:$L$1005
    SOLD =LEADS!$L$6:$L$1005
    TAKEN =LEADS!$K$6:$K$1005


    In C21:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

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

    Re: Formula Needed to count sales on one sheet based on data in multiple cells on another

    thanks big time

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula needed to auto populate in sheet2 & sheet3 based on test typed into cells in sheet
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2015, 10:15 AM
  2. Replies: 13
    Last Post: 06-02-2014, 12:58 AM
  3. Replies: 1
    Last Post: 05-31-2014, 01:38 AM
  4. [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
  5. [SOLVED] Formula Needed to count based on entries into 2 other cells.
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2013, 08:01 PM
  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. Help needed to perform COUNT based on multiple criteria
    By mattzz11 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-26-2012, 03:25 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