View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BrianLW BrianLW is offline
external usenet poster
 
Posts: 1
Default sum column based on multiple criteria

Good evening,

I am trying to work with the following data:
1 User at top level
2. Login type is 1 of three, UI, Tool, Interface
3. User may login multiple times per day

Need to capture all data from DB
Columns are
Session_ID
Start_Time
End_Time
Login_Minute
Login_Hours
User_Name
Login_Type

Formula I am trying to create is By User_Name, Time for Login_Type per day
and carry all data for the row to be used in the pivot table as one total per
day instead of mulitiples.