Sum multiple fields but not duplicate records

[Perk1961]

I am trying to figure out a formula for calculating the total value of a set of records, but not include any records that are duplicate. For example, I am trying to figure out two numbers.

1. Total value of all the properties a real estate agent held an Open House for.
2. The Total value of all the properties a real estate agent held an Open Houser for during a given period of time (i.e. 12 months.

Of course I can easily calculate the first, but the second one is rather challenging.

On one tab I list all the Open houses along with their address and asking price. On a separate tab I list all the days the agent held the Open House along with the address. The only common denominator is each tab includes the address of the property.

See attached excel.

Thanks in advance.

[DBY]

Hello
Not sure if I've got what you require but take a look at the attached file. It uses an helper column to make the calculation.

Just a note, is any of this data confidential? if so it may be advisable to change it.

DBY

[Perk1961]

That's it! Thank you very much.

Also, the data I shared is public information as it is all listed online.

Thanks again!

[DBY]

Hello
I've just gone over what I posted yesterday and I think there is an error in the file I provided. The helper column shows the price of each property at the first instance of it's appearance in the list but if that is outside of the date range supplied on the Summary tab then it won't be calculated. Take a look at the amended file, is this more accurate?

[Perk1961]

Great catch!! Thanks for your update and amended file. I opened it up to see your revised formula and initially saw a "#Ref" error, but was able to identify the issue and modify the formula to correct it. The new formula for cell E13 is:
"=SUMIFS('Open House Dates'!$I$4:$I$50000,'Open House Dates'!$B$4:$B$50000,">="&E4,'Open House Dates'!$B$4:$B$50000,"<="&E5)"

Note that I also changed the number of rows in the column to 50000 as I will be adding to this worksheet and did not want to disrupt the calculation. I did the same for the second tab.

Thanks so much for the amended look and attention to detail This does make a difference.

Regards.