Results 1 to 4 of 4

SumIf and CountIf for multiple columns having same header in a table

Threaded View

  1. #1
    Registered User
    Join Date
    03-27-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    58

    SumIf and CountIf for multiple columns having same header in a table

    There is a skill matrix (attached herewith the xls) where from i need to calculate the total of current skills numbers under several skill headers.
    Total is 22 [=SUMIFS(C13:H18,C13:H18,">="&"1",C13:H18,"<="&"4",C12:H12,"Cur")] this is not working
    As well,
    sum of all numbers under Tar columns >>not working >> =SUMIFS(C14:H19,C14:H19,">="&"1",C14:H19,"<="&"4",C13:H13,"Tar")
    Count of all cells with a number under Cur >> not working>> =COUNTIFS(C12:H12,"Cur",C13:H18,">="&"1",C13:H18,"<="&"4")
    Count of all cells with a number under Tar >> not wporking >> =COUNTIFS(C13:H13,"Tar",C14:H19,">="&"1",C14:H19,"<="&"4")

    Could someone please help me with these formulae? Thanks in advance.
    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. Replicate COUNTIF and SUMIF across multiple columns
    By mandu22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2021, 04:28 AM
  2. [SOLVED] Countif and sumif columns based on another cells as parameters
    By MyStix01 in forum Excel General
    Replies: 3
    Last Post: 11-27-2018, 08:31 AM
  3. [SOLVED] Multiple If, Countif, Sumif
    By callummcgrath in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-13-2017, 12:49 PM
  4. Using =SUMIF,=COUNTIF, and =AVERAGE to find specific values in columns
    By ExcelNub83 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2015, 07:53 PM
  5. [SOLVED] Excel - SUMIF/COUNTIF multiple columns
    By heatwave in forum Excel General
    Replies: 4
    Last Post: 06-16-2014, 08:45 AM
  6. [SOLVED] Convert table with multiple header columns into a pivotable table
    By jasonleewkd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2013, 03:20 AM
  7. Replies: 2
    Last Post: 10-13-2012, 03:30 AM

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