Hi everyone. I'm an intermediate-level formula user and understand basic stuff well. Have one need that is beyond my experience now.

Sheet 1
Column A has multiple instances of eight different values down 200 rows (and more added as I go - rows, not values; will always be one of the same eight in each new row)
Column B, Column D and Column E have values I'm interested in conditionally summing

County Quantity Date Requested Qty Delivered Qty Placed
Jefferson 50 Sep 5 50 28
Lake 30 Aug 31 30 30
Lake 50 Sep 15 35 23
Teller 100 Sep 1 100 100
Teller 100 Sep 15 100 78


Sheet 2
I want three different totals associated with Column A values in one row for each unique value of Column A

County Requested Delivered Placed
Jefferson 50 50 28
Lake 80 65 53
Teller 200 200 178

Would like Sheet 2 to be locked and show me current information as I update Sheet 1

Your suggestions are much appreciated!!

?A