Results 1 to 6 of 6

using countif with multiple corresponding criteria

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2010
    Location
    Syracuse, NY
    MS-Off Ver
    Excel 2003
    Posts
    3

    using countif with multiple corresponding criteria

    Ok, what I'm trying to do is to make a logbook for a machining center. Each part has an op10 and an op20, essentially front and back. And each part number falls into the category of OS or FS. I've used AND logic to make tables in hidden columns to be used by a countif statement to determine my totals.
    I.e. to determine if a scroll is completed, op20 has a a value of 1 AND column C is "OS".
    I use
    =IF(AND(A9=1;C9="OS");1;" ")
    Then I countif criteria is 1 in the column i created with that statement.

    That works just fine.
    Now what I want to do is to be able to create daily totals of OS and FS by simply modifying a variable date in a formula. So I'd like to essentially say:
    Countif Column C =OS and Corresponding column D = 1, and corresponding Shift date = 10.02.12(date to be variable).

    I'm at a wall here. Is there any way to do this somewhat simply?
    \1
    Attached Images Attached Images
    Last edited by macmandan1; 02-15-2010 at 09:58 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