can I use IF with SUMPRODUCT?????

S

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
 
L

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)))
 
S

SBecker

Luke,

Perfect!! Thank you so much....

Suzanne

Luke M said:
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



.
 

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