S
SBecker
I have a formula that gives me the average sales price for properties that
fall within a certain value. I would like to break it down further by
designating these same averages by state rather than just overall. Here is
my existing formula:
=(SUMPRODUCT(--($E$2:$E$495>50000),--($E$2:$E$495<75001),$D$2:$D$495)/SUMPRODUCT(--($E$2:$E$495>50000),--($E$2:$E$495<75001)))
I would like to add state criteria to this, such as all properties in CA.
How can I accomplish this?
I'd greatly appreciate any suggestions!!!
Thanks
Suzanne
fall within a certain value. I would like to break it down further by
designating these same averages by state rather than just overall. Here is
my existing formula:
=(SUMPRODUCT(--($E$2:$E$495>50000),--($E$2:$E$495<75001),$D$2:$D$495)/SUMPRODUCT(--($E$2:$E$495>50000),--($E$2:$E$495<75001)))
I would like to add state criteria to this, such as all properties in CA.
How can I accomplish this?
I'd greatly appreciate any suggestions!!!
Thanks
Suzanne