Results 1 to 8 of 8

COUNTIF multiple criteria?

Threaded View

  1. #1
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    COUNTIF multiple criteria?

    I am trying to count have many people have working in a 24h period. Each shift is represented by a letter of the alphabet. As an example , lets say there are 3 shifts. Early, Late and night shift.
    Early shift = A
    Late Shift = B
    Night Shift = C
    With this, I can count have many people worked in the 24 hour period by using a simple countif code to count each letter A,B,C.

    But, I need to count how many full time workers and part time workers there are as a second criteria.
    I tried this formula to count full time workers with no success.

    =SUMIF(B2:B19,"Full",(COUNTIF(C2:C19,{"A","B","C"}))
    I have attached a dummy workbook.
    Any help would be appreciated.
    Attached Files Attached Files
    Last edited by JapanDave; 04-24-2012 at 07:48 AM.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help 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