Sum formulation problem

[AjaxOfTheRockies]

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

[pjwhitfield]

Apologies if I've misread the question.

=SUMIF(Sheet1!$A$2:$A$6,A10,Sheet1!$B$2:$B$6)

Will calc the Requested, then just change the last column reference to do the other two

[Sam Capricci]

sheet 2, col B, =SUMIF(Sheet1!A:A,Sheet2!A2,Sheet1!B:B)
same sheet, col C =SUMIF(Sheet1!A:A,Sheet2!A2,Sheet1!D:D)
col D =SUMIF(Sheet1!A:A,Sheet2!A2,Sheet1!E:E)
I gave you full ranges because you said you were going to add data.

[AjaxOfTheRockies]

Thanks Everyone!! Worked perfectly