+ Reply to Thread
Results 1 to 2 of 2

Counting multiple Conditions

  1. #1
    Registered User
    Join Date
    02-09-2012
    Location
    Yorkshire
    MS-Off Ver
    Excel 2003
    Posts
    1

    Post Counting multiple Conditions

    Hey Forum,

    I am new on here and hope someone can be so kind as to help me with a formula problem that is bugging me..

    So I am looking at 4 different totals -

    Eg.

    5 Managers
    5 Supervisors
    5 Team Leaders
    5 Shift Workers

    It is based on a calender and at any one time i need one crew available (1 Manager, 1 Supervisor, 1 Team Ldr and 1 Shift Worker to make one complete crew)

    Is there a formula that can count how many available crews i will have according to how many of each type of staff are available?

    Some days I may only have 1 supervisor but 5 managers, 5 supervisors and 5 Shift workers although this would result in 1 crew available...

    Really hope someone can help..

  2. #2
    Valued Forum Contributor
    Join Date
    12-05-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010 & 2013
    Posts
    308

    Re: Counting multiple Conditions

    Hi Joey

    Please could you post some example data (i.e. a spreadsheet) so we can see the format of the data? Without this, we can't write the formula for you. Press the Go Advanced button below, then Manage Attachments.

    Without any visibility of the data, my only comment would be that it sounds quite possible. Probably SUMIF, COUNTIF, SUMPRODUCT or similar, with a MIN statement, e.g.:
    Please Login or Register  to view this content.
    Cheers, Rob.
    Last edited by rscsmith; 02-09-2012 at 08:54 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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