Hi Loungers. I need some help with COUNTIF and other 'counting' formulae. I have an assignment workbook (see sample attached). Jobs are assigned, usually, as a full day assignment. However, they can be 1/2 day jobs, or combined with another job (eg: Job 1-AM, Job 2-PM). The assignments are made on the Assignment w/sheet; these copy over onto a Weekly w/sheet that is posted online. The YTD w/sheet tallies all assignments....this is easy to do if there is only 1 assignment per day.......right now, I simply tally up all occurences (or 'mention") of each assignment but this is misleading if there are 1/2 day jobs.....eg: Hospital-AM counts as 1 'Hospital' assignment, even though it is only 1/2.....you will see examples of this on the attached workbook......the only place this doesn't happen is with vacation b/c I count VAC (and VAC-AM and VAC-PM) separately and add it all up.....but I don't want to have to make multiple columns for each assignment (in some cases there are 30 assignments, and these would make the YTD w/sheet very awkward).
Any suggestions or formulae help would be appreciated....thanks, as always.