+ Reply to Thread
Results 1 to 3 of 3

Using COUNTIFS to count sales

  1. #1
    Registered User
    Join Date
    11-30-2021
    Location
    Phoenix, Arizona
    MS-Off Ver
    Microsoft 365 MSO (Version 2110 Build 16.0.14527.20270) 64-bit
    Posts
    5

    Using COUNTIFS to count sales

    We have a list of clients who want us to send them quotes. I'm trying to count how many quotes each employee sends to the client.


    The employee will add their initials in column E.
    The employee will add the date in column F when they send out the quote, but some employees add the date in column F as they begin the quoting process. I don't want to count those. I only want to count it if the quote has actually been sent to the client.

    When the quote has been sent out to the client, the employee adds an "X" to column C or D (emailed or called). It doesn't matter which column (or both) have an "X" as long as at least one of the columns does. So if there is an "X" in column C & D then it should only count as 1 quote completed.

    Column I has a data validation list of each employees initials. I2 is the first employee's initials.

    Row 1 (starting in column J) has the dates.

    Here's what I have tried:

    =IF(AND(OR($C:$C="X",$D:$D="X")$E:$E=I2,$F:$F=J1),COUNTIFS(E:E,I2,F:F,J1),0)

    Thank you in advance!
    Attached Files Attached Files
    Last edited by analyst_; 12-01-2021 at 01:42 PM.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,910

    Re: Using COUNTIFS to count sales

    Try this in J2:

    =SUMPRODUCT((($C$1:$C$100="X")+($D$1:$D$100="X")>0)*($E$1:$E$100=$I2)*($F$1:$F$100=J$1))

  3. #3
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Using COUNTIFS to count sales

    I transposed your table for better visualization.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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] count product sales by month
    By bkjacobs in forum Excel General
    Replies: 1
    Last Post: 04-08-2021, 12:50 PM
  2. [SOLVED] % of sales increase/decrease depending on new 2020 sales vs 2019 sales.
    By scubakerny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2020, 08:05 PM
  3. [SOLVED] Countifs?? Sales---
    By thursday140 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-06-2016, 09:17 AM
  4. Counting customer by sales stage & type - complex countifs(...)
    By Tommyy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-13-2014, 12:41 PM
  5. Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  6. count sales rate
    By keuninkske in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-13-2013, 04:55 PM
  7. Count If-Sales Rep Name
    By rmeister in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-28-2006, 10:55 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