Results 1 to 5 of 5

Counting a sample (rows in a column) based on two criteria

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2013
    Location
    Madrid, Spain
    MS-Off Ver
    Excel 2011, Mac
    Posts
    19

    Counting a sample (rows in a column) based on two criteria

    Hi guys, here is my question..

    Imagine you have two columns: One with values a, b, c or /; and the other with values ranging from 69 to 84 (these are short for years).
    I have attached a sheet to make it more clear.

    What I need is to count how many values a, b and c I have in each year.

    What I have done so far is filtered the sheet, and then used a count function for each combination of (a,b,c) with (69-84).
    This works fine, but takes a lot of time, so I wanted to see if there is a shortcut.

    Thx
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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