+ Reply to Thread
Results 1 to 3 of 3

SUmifs / countifs?

  1. #1
    Registered User
    Join Date
    05-26-2010
    Location
    Auckland, NZ
    MS-Off Ver
    Excel 2003
    Posts
    52

    SUmifs / countifs?

    HI

    Here is what i attempted:

    =SUM(COUNTIFS('QREC Manage Job Requisitions |I'!N:N,{"2","3H","3L","4",'QREC Manage Job Requisitions |I'!W:W)

    Essentially if there is anything in column n that matches 2,3h,3L or 4 then I would like all the numbers in column W counted up for a total...

    Ive spent around 2 hrs believe it or not and was so pleased when i was able to count the N column only...

    But alas I would appreciate any help

    Izzy

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

    Re: SUmifs / countifs?

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: SUmifs / countifs?

    You want SUMIF to sum column W, based on criteria in column N, i.e.

    =SUM(SUMIF('QREC Manage Job Requisitions |I'!N:N,{"2","3H","3L","4"},'QREC Manage Job Requisitions |I'!W:W))
    Audere est facere

+ 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. Countifs or sumifs
    By jyadayada in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-26-2017, 07:59 AM
  2. Countifs & sumifs Help!
    By Roo007 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2016, 09:39 PM
  3. Help on SUMIFS and COUNTIFS
    By NDmad in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-24-2016, 05:14 PM
  4. [SOLVED] SumIfs and CountIfs Help
    By ScabbyDog in forum Excel General
    Replies: 1
    Last Post: 03-14-2016, 06:37 AM
  5. [SOLVED] Countifs or Sumifs
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-29-2015, 12:15 PM
  6. [SOLVED] Tell me about countifs & sumifs
    By keshavtale in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-29-2015, 09:01 AM
  7. Countifs or Sumifs
    By RalstonT14612 in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 11-30-2014, 02:02 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