If response appears, total amount in another column

LMallery

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".

Jeff M.

You could try a formula in a new column. =IF( [Application Status]@row = "Approved", [Amount Awarded]@row, ""). You could then summarize this column to show the total awarded amount.

LMallery

I am actually trying to do this in a summary sheet. I don't want to build it into the application.

Jeff M.

If you create a sheet summary from the options to the right of the sheet. Create a text/number column named "Total Awarded" or similar, and insert a formula into that. =SUM(COLLECT([Total Award Amount]:[Total Award Amount], [Approval Status]:[Approval Status], = "Yes"))

Or insert the formula into the cell of the summary sheet column your working on, but reference the columns from the master sheet.