Calculating when double up of information

[Vegas01]

Afternoon

Below is a sample of data, Column D (Ward) - this the unique identifier but has appeared twice in the data pull I have.

How do I calculate the total in Column C (TotalPatie) with only 1 incident of Column D (Ward)

Where there is a double up of Column D (Ward) the amount in Column C needs to be added to the highest number that it relates to in Column A and not on the lower number is column A

Therefore I would like to see

Column A Column D
1463 ALN2 sum 1 - nothing sum for 757
1463 ALP4 sum 7 - nothing sum for 757
1463 ALP5 sum 10 - nothing sum for 757
1463 ALP6 sum 12 - nothing sum for 757
1463 ALP7 sum 13 - nothing sum for 757
1463 ALPS sum 7 - nothing sum for 757


Giving a total of 79 for 1463 Community
Total of 0 for 757 Community


Hope this make sense
Thanks in advance

 

[RobP]

From your data, its hard to know if you always have only 2 types of number in Col A.

But does this give you what you need ? (its checking colA for the "1463" reference instead ? (an is this always the same reference ?)

=SUMIFS(C2:C17,A2:A17,"=1463")

I used SUMIFS initially as I wasn't sure if there was further criteria to be added later...

cheers
Rob