Results 1 to 5 of 5

Count of multiple criteria

Threaded View

chavanalini Count of multiple criteria 06-28-2021, 12:40 PM
Limor_OP Re: Count of multiple criteria 06-28-2021, 12:52 PM
chavanalini Re: Count of multiple criteria 06-28-2021, 01:25 PM
chavanalini Re: Count of multiple criteria 06-28-2021, 01:26 PM
JohnTopley Re: Count of multiple criteria 06-28-2021, 01:22 PM
  1. 06-28-2021, 12:40 PM #1
    chavanalini is offline
    Registered User
    Join Date
    03-06-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    95

    Count of multiple criteria

    Dear team,

    I have 2 excel files. One excel file is have raw data with more than 1000 records with 50 columns and second excel file have state names in Column A1:A12 with column headings of side effects (SE) . I want to count the number of SEs reported state wise in the second excel file from raw data.

    I tried with countifs but I got all zeros. Can any one help me to get this done.

    I have attached the sample files for your reference

    Thanks in advance
    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. How to count the number of criteria in a column when there is multiple criteria in a cell
    By Excellent135 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-07-2021, 06:04 PM
  2. Count with multiple criteria (Date, Time and Other Criteria)
    By Naren_Kumar in forum Excel General
    Replies: 6
    Last Post: 06-25-2018, 05:53 PM
  3. Count cells if any criteria are met, not multiple criteria
    By jesstaylor in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-03-2014, 12:50 PM
  4. Count number of Rows with multiple criteria (multiple valued cells)
    By garog in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-09-2014, 01:33 PM
  5. Multiple Criteria search and COUNT FOR TEXT across multiple sheet ARRAY's
    By akaushik25 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2014, 08:58 AM
  6. Count statement wtih multiple criteria only showing results for one criteria
    By uhlabomber in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 02:47 PM
  7. Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria
    By gtj_global in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2008, 06:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1