can I use IF with SUMPRODUCT?????

[SBecker]

I have the following 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)))

Which is calculating averages of property values between specified ranges.
I would like to be able to drill further into this data by grouping the
averages by state.

Suggestions?

Thanks,
Suzanne

 

[Luke M]

Why not add it as a criteria in your SUMPRODUCT?

=(SUMPRODUCT(--($E$2:$E$495>50000),--($E$2:$E$495<75001),--(B2:B495="My
State"),$D$2:$D$495)/SUMPRODUCT(--($E$2:$E$495>50000),--(B2:B495="My
State"),--($E$2:$E$495<75001)))

 

[SBecker]

Luke,

Perfect!! Thank you so much....

Suzanne

Why not add it as a criteria in your SUMPRODUCT?

=(SUMPRODUCT(--($E$2:$E$495>50000),--($E$2:$E$495<75001),--(B2:B495="My
State"),$D$2:$D$495)/SUMPRODUCT(--($E$2:$E$495>50000),--(B2:B495="My
State"),--($E$2:$E$495<75001)))

--
Best Regards,

Luke M



.