I currently have a sheet set up where I am calculating the total revenue generated for all the tasks listed underneath the main header using the =SUM(CHILDREN()) formula. All the tasks listed underneath the header in the status column is being classified as awarded, cancelled, pending and unsuccessful as shown in the screenshot below. Would it possible to update the total revenue formula such that it only sums the revenue of the tasks underneath if the status is awarded, pending and unsuccessful? So basically it should exclude the total revenue if the status of any task is changed to "awarded". I am happy to add another helper column in the sheet or create a seperate formula sheet that would just calculate this metric for me because eventually I would like this metric to be displayed in a dashboard so it wouldn't matter where the metric is being stored.