Sum using multiple rows

[Chris3177]

I am trying to sum data from multiple rows using the same criteria. The spreadsheet is below


-- removed inline image ---


I would like to write a formula that looks at the row labeled "Position" and sums all values in the row labeled "Total FTE (Year)" for with "mng" is in the "Position" row? I would like to do this for the other labels as well such as "PD" and "Director."

Is this possible via a formula and if so, what is the formula?

Thank you!

 

[Chris3177]

The picture of the excel spreadsheet did not come through.

-- removed inline image ---

 

[Chris3177]

How can I add a snap shot of my excel spreadsheet?