This is a sample of office Stats and I want to SUM all of the "Dizziness" from C2:H6 but only take the LAST instance if there is a duplicate in a Patient Name. Note: there will be multiple patients retaking the survey at least 3-4 times. [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]
[TD="width: 65"]Timestamp[/TD]
[TD="width: 65"]Patient Name[/TD]
[TD="width: 65"]Condition 1[/TD]
[TD="width: 65"]Rate[/TD]
[TD="width: 65"]Condition 2[/TD]
[TD="width: 65"]Rate[/TD]
[TD="width: 65"]Condition 3[/TD]
[TD="width: 65"]Rate[/TD]
[TD="align: right"]3/6/18[/TD]
Test 2
[/td]Dizziness
[/td]
[TD="align: right"]5[/TD]
Fatigue
[/td]
[TD="align: right"]5[/TD]
Fainting
[/td]
[TD="align: right"]5[/TD]
[TD="align: right"]3/7/18[/TD]
Test 3
[/td]Sciatica
[/td]
[TD="align: right"]3[/TD]
Dizziness
[/td]
[TD="align: right"]5[/TD]
Tinnitus
[/td]
[TD="align: right"]10[/TD]
[TD="align: right"]3/8/18[/TD]
Test 2
[/td]Dizziness
[/td]
[TD="align: right"]5[/TD]
Fainting
[/td]
[TD="align: right"]6[/TD]
Fatigue
[/td]
[TD="align: right"]6[/TD]
[TD="align: right"]3/9/18[/TD]
Test 4
[/td]Neck Pain
[/td]
[TD="align: right"]6[/TD]
Sciatica
[/td]
[TD="align: right"]6[/TD]
Vertigo
[/td]
[TD="align: right"]6[/TD]
[TD="align: right"]3/10/18[/TD]
Test 2
[/td]Fatigue
[/td]
[TD="align: right"]8[/TD]
Fainting
[/td]
[TD="align: right"]8[/TD]
Dizziness
[/td]
[TD="align: right"]10[/TD]
DIZZINESS
[/td]
[TD="align: right"]15[/TD]
[TD="align: right"] [/TD]
25
[/td]
[/TABLE]
I know my result should be 15 from Test 2 and Test 3, but I don't want to capture Test 2's duplicate from other dates which would give me a total of 25 (was using =SUMIFS(D2:H6,C2:G6,C8). Help please?
James