How can I calc totals for specifc techs on a specific date?

F

Francis

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
 
S

shg

If you want to use a formula,

=SUMPRODUCT( (Sheet2!$O2:$O2175 = F4) * (Sheet2!E2:E2175 = A5) )
 
S

ShaneDevenshire

Since there is no message I presume you want to know how? Lets suppose your
data, with one row of titles, starts in A1

1. Place your cursor in the data and choose Data, PivotTable & PivotChart
Report
2. Click Next, if the selected range is correct click Next
3. Click Layout and drag the Tech field button into the Row area, then drag
the Date field into the Row area below the Tech field. Drag the Tech field
into the Data area (notice it says count of tech) and click OK. Click Finish
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count based on multiple criteria 2
Average a group of numbers within an date range. 4
can I sum information in a list 1
Date determination and sums 0
Creating a percent of total in a grouping level on a report 2
How do I add a variable range of columns depending on criteria 0
How to check for a date range match in one column and then count thevalues equal to in another 5
how do I sort a spreadsheet of daily events into weekly totals? 1

Top