+ Reply to Thread
Results 1 to 2 of 2

To find a summary on 2 columns multiple data

  1. #1
    Registered User
    Join Date
    05-23-2011
    Location
    Dammam
    MS-Off Ver
    Excel 2003
    Posts
    7

    Question To find a summary on 2 columns multiple data

    I need a solution to the problem below:
    I've a table and in the first column titled 'VALUES' (A1) I've entered values ranging from 1 to 100 (A2:A10). In the second column titled 'STATUS' (B1), 'closed' or 'NA' is entered (B2:B10). Now I need to find how many cells are there in the table with 'closed' status in the range 0-25, 26-50, 51-75 and 76-100.
    VALUES STATUS
    34 Closed
    56 NA
    44 Closed
    98 Closed
    18 NA
    82 NA
    23 Closed
    40 NA
    63 Closed
    71 Closed

    Closed Status Count
    0 - 25 :
    26 - 50 :
    51 - 75 :
    76 - 100 :

    please give me a solution.
    Last edited by sherifpv; 05-22-2014 at 05:10 AM. Reason: for clarity

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: To find a summary on 2 columns multiple data

    Not clear enough. A small sample workbook will helps us to help you.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ 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. [SOLVED] Copy multiple worksheets data & paste into blank columns in summary worksheet
    By guest99999 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-21-2013, 09:56 AM
  2. Loop to Find the Max Value of Data in Multiple Columns
    By Gard5096 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2012, 12:45 AM
  3. Create Summary from multiple sheets with variable columns
    By mccrimmon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2011, 02:31 PM
  4. Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Columns
    By nzxt1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 01:17 AM
  5. Replies: 0
    Last Post: 10-23-2008, 04:37 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1