EXAMPLE  SUMIF Function
This example can be used to sum the values in a column based on a condition and organized by group.
Function:
Item  Description 

SUMIF Function  Generates the sum of rows in each group that meet a specific condition. 
WEEKDAY Function  Derives the numeric value for the day of the week ( 
Source:
The following data identifies sales figures by salespeople for a week:
EmployeeId  Date  Sales 

S001  1/23/17  25 
S002  1/23/17  40 
S003  1/23/17  48 
S001  1/24/17  81 
S002  1/24/17  11 
S003  1/24/17  25 
S001  1/25/17  9 
S002  1/25/17  40 
S003  1/25/17  
S001  1/26/17  77 
S002  1/26/17  83 
S003  1/26/17  
S001  1/27/17  17 
S002  1/27/17  71 
S003  1/27/17  29 
S001  1/28/17  
S002  1/28/17  
S003  1/28/17  14 
S001  1/29/17  2 
S002  1/29/17  7 
S003  1/29/17  99 
Transformation:
You want to know how your salespeople are doing by the day of the week. To the above, you add a column that identifies the day of the week:
Transformation Name 


Parameter: Formula type  Single row formula 
Parameter: Formula  WEEKDAY(Date) 
Parameter: New column name  'DayOfWeek' 
First you wish to examine weekday sales, when DayOfWeek < 6
. For each day of the week, you can preview the following aggregation:
Transformation Name 


Parameter: Row labels  groupId 
Parameter: Values  sumif(Sales, DayOfWeek < 6) 
Performance is listed in the following order: S001, S002, S003.
To analyze the weekend, you change the above to the following:
Transformation Name 


Parameter: Row labels  groupId 
Parameter: Values  sumif(Sales, (DayOfWeek >= 5)) 
Results:
The following are the results for the weekend:
EmployeeId  sumif_Sales 

S001  42 
S002  126 
S003  142 