Results 1 to 4 of 4

Sumifs with Criteria 1 as range rather than cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2020
    Location
    new jersey
    MS-Off Ver
    2019
    Posts
    56

    Sumifs with Criteria 1 as range rather than cell

    Hi,

    I am working on a file where I need a sum of all the quantities sold during a month for a specific list of sales persons IDs as listed in the file in Column P. File is attached for your reference. I tried Sumifs but it's not working in this case. Maybe some other formula or trick might work.

    Thanks,
    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. Replies: 1
    Last Post: 04-09-2021, 11:09 AM
  2. [SOLVED] Usine sumifs to change criteria range column based on dynamic criteria
    By Luiscarlos in forum Excel General
    Replies: 5
    Last Post: 11-19-2020, 09:33 AM
  3. SUMIFS for date range (read from a cell) and text criteria not working
    By meny_ in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-03-2019, 06:23 AM
  4. Replies: 3
    Last Post: 02-02-2017, 04:32 AM
  5. Replies: 5
    Last Post: 10-03-2016, 03:39 AM
  6. Replies: 3
    Last Post: 11-21-2012, 04:57 PM
  7. Replies: 1
    Last Post: 05-16-2011, 05:00 PM

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