Results 1 to 4 of 4

Data summary based on multiple criteria

Threaded View

  1. 02-26-2021, 07:20 AM #1
    Berna11
    Berna11 is offline
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Data summary based on multiple criteria

    Good morning
    nice file attached I can not understand why with the test formula in M4 it does not give me the result that I expect

    to get that result I also changed the reference = I4 corrected
    to = I3 one line before ...

    What I would like to achieve in column J
    are the data of column E based on item column B = column I
    column C = NO
    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Summary of daily data based on different criteria
    By Anuru in forum Excel Formulas & Functions
    Replies: 63
    Last Post: 05-23-2018, 02:03 PM
  2. [SOLVED] VBA countif based on multiple criteria - paste to a summary table in another sheet
    By sloshpuppy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2018, 07:15 AM
  3. Consolidating data from multiple worksheets into a summary sheet having multiple criteria
    By Marushka Pinto in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2015, 11:11 PM
  4. [SOLVED] Summary of data based on multiple criteria
    By Reapz in forum Excel General
    Replies: 2
    Last Post: 09-16-2015, 06:46 PM
  5. Create a summary sheet for multiple worksheets based on multiple criteria with formulas
    By Rbower333 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-03-2015, 06:27 PM
  6. Generating a data summary sheet based on multiple criteria
    By Anuru in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 07-18-2014, 08:03 PM
  7. Summary Based on Multiple Criteria
    By Phillycheese5 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2006, 11:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1