| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I calc totals for specifc techs on a specific date?
I need to calc the total number of help desk tickets completed by a tech on a
given date from a source worksheet that contains tickets for all techs on multiple dates. Using the below formulas I'm able to get the total tickets on a specifc date, and also get the totals by tech for the entire month. What I need is to calc the tickets by tech, by date. My select criteria in the fomulas is a cell from another worksheet =COUNTIF(Sheet2!$O2:$O2175,F4) = ticket counts by date =COUNTIF(Sheet2!E2:E2175,A5) = tickets counts by tech for the entire month |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) | Excel Discussion (Misc queries) | |||
| ND TO CALC FROM ORIG DATE TO NEXT DATE RECEIVED? | Excel Discussion (Misc queries) | |||
| How to calc #'s giving totals 1-15=1, 16-25=2, 26-35=3, etc | Excel Worksheet Functions | |||
| Calc End Date | Excel Worksheet Functions | |||
| calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions | |||
Threaded Mode
