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..
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.:
Cheers, Rob.=MIN(COUNTIF(A:A,"SUPERVISOR"), COUNTIF(A:A, "MANAGER"), COUNTIF(A:A,"TEAM LEADER"))
Last edited by rscsmith; 02-09-2012 at 07:54 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks