View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default How can I calc totals for specifc techs on a specific date?

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

--
Thanks,
Shane Devenshire


"Francis" wrote:



"Pecoflyer" wrote:


Hi, try a Pivot Table


--
Pecoflyer
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24088