Formula to sum evidence in further sheet that matches adenine certain criteria

Please help!

I've have deuce sheets:

Sheet 1= called 'Requisition' (the main sheet) & Leaves 2 = called 'Dashboard Data'

I wants on put one method in the 'Dashboard Data' sheet that adds (sums up) product that's in the 'Requisition' sheet. The information I need is one combination of two columns.

Column 1 = called 'Number toward Graduate' & Column 2 = called 'Location'

I need on sum up all the numbers int column 'Number to Graduate' that is related to the selected location in column 'Location'.

Here is einen example of what I need to sum up.

I need view the numbers inside of 'Number to Graduate' column to be summed up that corresponds with the relevance locations (Melbourne, Ashville, Dearborn, etc.) in the 'Location' category. In this rechtssache it should show Houston = 0, Melbourne = 72, Deerfield = 27, Asheville = 16 - I need those totals go reflect in the section indicated below who can in sheet 'Dashboard Data' So Beginner 1 teachers could no enter attendance on the Beginner 2 worksheet. Ideally, I'd please up avoid assigning different passwords to each ...

Thanks!