Formulas: Countif / And / Children Rows

Laura

H E L P!

What is a simple way to formulate the "Evaluation" Chart in the Screen Shots attached, based off ONLY the children rows of the 4 Departments on the top of the sheet in both the "status" and "risk level" columns? I'm trying to avoid a "messy" formula but I'm receiving an error through all my attempts. 

 

J. Craig Williams

I think I need more information to provide an answer. Can you send a screen shot of what you expect the sheet to be, assuming the formulas were working properly?

Craig

Laura

The 4 departments (Engineering, Scheduling, Supply Chain & Quality) each have tasks in their children rows and each task row has a STATUS Column of "Closed", "Work in Progress", "Behind" or "Not Started" and a RATING Column of "Extreme", "High", "Medium" or "Low".

 

I'd like the chart at the bottom to show the count of tasks per Status / Rating. I've tried a COUNTIF(AND) formula but received errors (assuming since I'm only wanting to count the children rows).

 

Example: # Tasks With a Closed Status and Extreme Rating.

 

 

Laura

(It wont let me edit or reply to above)

 

Correction - "Risk Level" Column not Rating column

J. Craig Williams

This should work then

=COUNTIFS(Status:Status,"Closed",[Risk Level]:[Risk Level],"Extreme")

=COUNTIFS(Status:Status,"Closed",[Risk Level]:[Risk Level],"High")

and so on.

( I typed that, but it looks OK)

Craig

Laura

Thanks Craig! I was trying to make a simple formula a LOT more difficult...