| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Function 2 Columns
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!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for a function to count alpha values in a range. | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Count Function Help | Excel Worksheet Functions | |||
| analysing data from alternate columns using the countif function | Excel Discussion (Misc queries) | |||
| Sum and Count Function | Excel Worksheet Functions | |||
Threaded Mode
