+ Reply to Thread
Results 1 to 2 of 2

How to Count/sum Column with MULTIPLE Criteria

  1. #1
    Registered User
    Join Date
    10-24-2022
    Location
    Buenos Aires
    MS-Off Ver
    19
    Posts
    7

    How to Count/sum Column with MULTIPLE Criteria

    I have a workbook with dates, products, and prices. I want to sum using 2 criteria from the same criteria range, for example, I want to know what is the total revenue of Wireless headphones and notebooks between 03/02/2002 and 05/02/2022. I was able to do it with one criteria of products and the between date, but could not do it with 2 products
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: How to Count/sum Column with MULTIPLE Criteria

    Try:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. Replies: 7
    Last Post: 04-07-2021, 06:04 PM
  2. [SOLVED] COUNT across multiple columns with single column criteria
    By AndyGW in forum Excel General
    Replies: 3
    Last Post: 08-13-2017, 08:36 AM
  3. [SOLVED] Need to Count Unique Values down a column with multiple criteria
    By RMerckling in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-21-2016, 07:39 PM
  4. [SOLVED] Search and count a word (*delay*) from 3rd Column with multiple criteria from row/column
    By suchetherrah in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2015, 06:00 PM
  5. [SOLVED] count with multiple criteria without duplicates based on a different column
    By antagonanin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2013, 09:46 AM
  6. [SOLVED] Count text in one column Matching single or multiple Criteria from Other Column Excel 2003
    By Jose Macieira in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-17-2013, 06:55 AM
  7. [SOLVED] Count different values in same column with multiple criteria
    By efernandes67 in forum Excel General
    Replies: 2
    Last Post: 06-03-2012, 10:48 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