Required vs. Completed formula help

Olga Bishop

I think this is an easy one but my brain is not firing correctly today.

I need a formula which will compare how many tasks in the "Required Milestones: OT" have actually been completed. So I have my formula for the required tasks =COUNTIF([Required_Milestones]:[Required_Milestones], "OT") but how do I get it to look at the status column for "Complete" to tell me how many of these have been completed.

Thanks!

Ben Goldblatt

Hi @Olga Bishop,

It sounds like you're on the right track with your formula but if you're looking to populate counts based off of multiple conditions (more than one range and more than one set of criteria), you can use the COUNTIFS function to accomplish this. Something like:

=COUNTIFS([Required Milestones]:[Required Milestones], "OT", Status:Status, "Complete")

I hope this helps!

Thanks,

Ben

Olga Bishop

Thanks Ben! It worked!