I need a formula to add values in multiple cells based on the value of another cell.

Good day. I have a spreadsheet where on one tab (Report Log), I have a running list of data inputted based on the number of reports. On another tab (Report Stat Total), I have the calculated values base on the Report Log tab. In column 'N' on the Report Log tab, I manually input a number for the number of sub reports for that line item. It could be any number depending on the amount of sub reports generated. What I need is a formula that will total the number of sub reports in column "N' on the Report Log based on the value of column 'F' on the Report Log tab and transpose that total to the Report Stat Total in column 'G' based on the value of column 'E'. For example if the values in column 'F' are 'Hutto High School' and the values in column 'N' are 4,6,2, and 1, put that total in the column 'G' cell that matches the value in column 'E'.

I have attached my spreadsheet so that maybe this makes sense.

Thanks

Just to clarify, you mention column N is 4,6,2,1. (which cell are you referring?)
so i assume the on report log N5 is 4,6,2,1 and F5 is Hutto High School? so you want to add up the total of that four number and return at stat total sheet column G5?

Or you mean each of that number goes to N5 to N8 cell and F5 to F8 is Hutto High School.