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
|