Calculated field formula SUMIF or SUM
Hi, I would like to create a formula that depends on a criteria of two different fields.
student name | department | class | grade
John | CS | Calculus | 10
Carmen | Chemistry | Calculus | 30
Jennifer | CS | Calculus | 0
How can I get sum of grades that are Calculus class and CS department?
Is there any built-in function in Archer to calculate intersection of two SUM like Excel's intersection(' ') eg: SUM(A1:A8 B1:B8)?
- calculated field
- Community Thread
- Forum Thread
- RSA Archer
- RSA Archer Suite
Did you try the SUMIF function with AND logical syntax.
For example :
SUMIF( AND(Condition 1, Condition 2) , [Field to sum])
Syntax: SUMIF(eval_field_ref, criterion)