Results 1 to 7 of 7

Count in series with multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    03-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Excel 2008 MAC
    Posts
    3

    Exclamation Count in series with multiple conditions

    I have a few formulas that I need to write but am having serious issues....

    1. Count all the "ASY" (column I) in a series if that row also contains a "Y" (column B) - Sheet: Data!

    2. Count all the "1" (column K) in a series if that row also contains "ASY" (column I) and "Y" (column B) {all on Sheet: Data!} then divide that by $B$2 to get the percentage of cells that have a 1 in that cell for ASY/Y rows
    Last edited by IslasLorax; 03-28-2012 at 06:01 PM.

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