Using If with SumProduct help please!

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
 
P

Per Jessen

Hi

I assume that you have states in column A, so I just added another condition
in the Sumproduct formulas. "CA" can be substitutet with a cell reference:

=SUMPRODUCT(--($E$2:$E$495>50000),--($E$2:$E$495<75001),--($A$2:$A$495="CA"),$D$2:$D$495)/SUMPRODUCT(--($E$2:$E$495>50000),--($E$2:$E$495<75001),--($A$2:$A$495="CA"))

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top