can I use IF with SUMPRODUCT?????
 

I have the following formula,

=(SUMPRODUCT(--($E$2:$E$49550000),--($E$2:$E$495<75001),$D$2:$D$495)/SUMPRODUCT(--($E$2:$E$49550000),--($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

can I use IF with SUMPRODUCT?????
 

Why not add it as a criteria in your SUMPRODUCT?

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

--
Best Regards,

Luke M
"SBecker" wrote in message
...
I have the following formula,

=(SUMPRODUCT(--($E$2:$E$49550000),--($E$2:$E$495<75001),$D$2:$D$495)/SUMPRODUCT(--($E$2:$E$49550000),--($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

can I use IF with SUMPRODUCT?????
 

Luke,

Perfect!! Thank you so much....

Suzanne

"Luke M" wrote:

Why not add it as a criteria in your SUMPRODUCT?

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

--
Best Regards,

Luke M
"SBecker" wrote in message
...
I have the following formula,

=(SUMPRODUCT(--($E$2:$E$49550000),--($E$2:$E$495<75001),$D$2:$D$495)/SUMPRODUCT(--($E$2:$E$49550000),--($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


.