Results 1 to 10 of 10

Get data from multiple criteria of single column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-03-2014
    Location
    India
    MS-Off Ver
    2016 .......
    Posts
    393

    Lightbulb Get data from multiple criteria of single column

    Hi all,
    pls find attachment of file

    I want result specified in file

    I used formula in K4 but showing error

    {=SUM(SUMIFS($C$4:$F$15,$B$4:$B$15,"="&$J4,$A$4:$A$15,"="&$K$2,$C$2:$F$2,"="&$I$19:$I$20))}
    Attached Files Attached Files
    Last edited by sanjuss2; 06-27-2022 at 03:54 AM.
    Regards,
    Sanjay SS
    __________________________________________________________________________________________________________________________
    Good Luck !!!
    If you feel I have helped, please click on the star to the left of the post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember......Mark Thread as Solved.
    Excel Forum Rocks!!!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Countifs Multiple criteria for single column
    By JoelleM92 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-04-2021, 05:14 PM
  2. [SOLVED] Capturing Multiple Column’s Data in a Single Column Based on Criteria
    By Rajeshkumar R in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2020, 01:40 PM
  3. [SOLVED] Return single value by searching multiple criteria in multiple column
    By Ramesh h&m in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 07-01-2017, 07:02 AM
  4. [SOLVED] Copy column data from multiple worksheets to single worksheet based on header criteria
    By nateaskins in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-21-2014, 10:42 AM
  5. [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
  6. [SOLVED] Pull data if there is any from a single column in multiple worksheets into a single sheet
    By bcas77 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 07-11-2013, 01:22 PM
  7. Average Multiple Criteria Single Column
    By mma3824 in forum Excel General
    Replies: 2
    Last Post: 12-14-2012, 02:36 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