In Column B I have up to 30 different center #'s (example 50101, 50202, 50303
and so on) In column K, I have either "Overnight" or "After Hours". I need a
formula on a seperate sheet (center #'s as headers, doesn't matter vertical
or horizontal) to return how many Overnights there are and how many After
Hours per month. A Pivot Table will work (too easy) but I'm dealing w/
non-excel users who keep breaking the pivot table and now all the data is
sorted on monthly worksheets rather than all data on one sheet.
Thanks in advance!!!!