SUM but only the last instance / occurrence if there are duplicates

  • 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"]

    [tr]


    [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]

    [/tr]


    [tr]


    [TD="align: right"]3/6/18[/TD]

    [td]

    Test 2

    [/td]


    [td]

    Dizziness

    [/td]


    [TD="align: right"]5[/TD]

    [td]

    Fatigue

    [/td]


    [TD="align: right"]5[/TD]

    [td]

    Fainting

    [/td]


    [TD="align: right"]5[/TD]

    [/tr]


    [tr]


    [TD="align: right"]3/7/18[/TD]

    [td]

    Test 3

    [/td]


    [td]

    Sciatica

    [/td]


    [TD="align: right"]3[/TD]

    [td]

    Dizziness

    [/td]


    [TD="align: right"]5[/TD]

    [td]

    Tinnitus

    [/td]


    [TD="align: right"]10[/TD]

    [/tr]


    [tr]


    [TD="align: right"]3/8/18[/TD]

    [td]

    Test 2

    [/td]


    [td]

    Dizziness

    [/td]


    [TD="align: right"]5[/TD]

    [td]

    Fainting

    [/td]


    [TD="align: right"]6[/TD]

    [td]

    Fatigue

    [/td]


    [TD="align: right"]6[/TD]

    [/tr]


    [tr]


    [TD="align: right"]3/9/18[/TD]

    [td]

    Test 4

    [/td]


    [td]

    Neck Pain

    [/td]


    [TD="align: right"]6[/TD]

    [td]

    Sciatica

    [/td]


    [TD="align: right"]6[/TD]

    [td]

    Vertigo

    [/td]


    [TD="align: right"]6[/TD]

    [/tr]


    [tr]


    [TD="align: right"]3/10/18[/TD]

    [td]

    Test 2

    [/td]


    [td]

    Fatigue

    [/td]


    [TD="align: right"]8[/TD]

    [td]

    Fainting

    [/td]


    [TD="align: right"]8[/TD]

    [td]

    Dizziness

    [/td]


    [TD="align: right"]10[/TD]

    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td]

    DIZZINESS

    [/td]


    [TD="align: right"]15[/TD]

    [td][/td]


    [TD="align: right"] [/TD]

    [td]

    25

    [/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/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