How to sum values in one column excluding cells with duplicate text values in two different columns?

[kakehavata]

Hello, forum! I'm new here.

I have the following basic problem. In this table I have three variables:

I am using the SUMPRODUCT formula to calculate the sum of all numbers in column C that have a particular index in column A. For example, C13 =SUMPRODUCT(($A1:$A7="A")*(C1:C7))
I would like to exclude all duplicates in terms of all columns, that is C1 and C3, for example, should be counted only once (C13 would then = 7).

What should I add to the formula?

Thank you!

 

[kakehavata]

I assume that you are following all the instructions described here.
What are the symptoms of the bug?
At what point in those instructions does the bug occur?

When I click on the Mini-sheet button the whole program freezes for some reason. I am using Excel 2016 at the moment.

EDIT: Now that I tried to work with the settings, it seems that the when "Named Ranges" is checked is when the bug occurs. Otherwise it seems to be working fine!

 

[jasonb75]

One more question: what if I want to add other variables using the COUNTIFS function?
So, for example, if we consider columns D and E:

In that example, are columns D and E part of the sum, or are they just criteria for identifying duplicate rows?

 

[kakehavata]

In that example, are columns D and E part of the sum, or are they just criteria for identifying duplicate rows?

they are just criteria for identifying duplicate rows.

I have also presented a more elaborate and accurate version of the chart I am trying to make here: How to exclude duplicate rows when summing values in columns

I found that, although I make the formulas work on a small scale, I can't seem to be able to transpose them to the actual project I am working on. So, if it's all the same to you, you can write your comment there.

I appreciate the help!