SUMIF question

[Guest]

I have a database referencing real estate property types (retail, industrial, office) in F3:F80, and property square footages in DK3V80 (1 column per month, 1 row per property), and the "Industrial" property type referenced in DL86. Because properties come & go throughout the year, I want to create a formula to sum the average square footages throughout the year by property type

I thought the following formula would work: =SUMIF(F3:F80,DL86,DK3V80)/12. However, this only returns the total of industrial square footages in column DK (1 month instead of the whole year) and then divides that by 12

Can anyone help?

 

[Jim]

Use this to find the average of each property type:
=SUMPRODUCT((F3:F80="Industrial")*(DK3V80))/COUNTIF(F3:F80,"Industrial")
You may then find the sum of the averages.
--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

I have a database referencing real estate property types (retail,

industrial, office) in F3:F80, and property square footages in DK3V80 (1
column per month, 1 row per property), and the "Industrial" property type
referenced in DL86. Because properties come & go throughout the year, I
want to create a formula to sum the average square footages throughout the
year by property type.

I thought the following formula would work:

=SUMIF(F3:F80,DL86,DK3V80)/12. However, this only returns the total of
industrial square footages in column DK (1 month instead of the whole year)
and then divides that by 12.