ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sum column based on multiple criteria (https://www.excelbanter.com/excel-worksheet-functions/174212-sum-column-based-multiple-criteria.html)

BrianLW

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.



All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com