|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
08-14-2014, 09:52 PM
|
||||
|
||||
As per the link in my previous post, you can calculate the # employees on a given day with:
=SUMPRODUCT((D2:K2<>0)/COUNTIF(D2:K2,D2:K2))-(COUNTIF(D2:K2,"Nobody on Duty")<>0)*1 in L2 and copied down as far as needed.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Lookup using 2 criteria | Itsbarbara | Excel | 16 | 10-07-2013 02:53 PM |
| Counting cells with multiple complex criteria | TishyMouse | Excel | 12 | 12-06-2012 05:05 AM |
| Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |
 Selecting blank cells in criteria
|
apolloman | Excel | 6 | 08-24-2011 05:38 AM |
| How to count cells containing data and meet certain criteria | AdamNT | Excel | 1 | 08-11-2006 11:51 PM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode