If response appears, total amount in another column
Is it possible to sum a set of responses if a condition is met in another column? For example: I have a column that indicates application approval status. I have another column that indicates the total award amount. This award amount column contains amounts whether the application status has been approved or not (inprocess). I need to summarize the total amount awarded for all applications with an approval status of "yes".
Help Article Resources
Check out the Formula Handbook template!