| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| SumProduct? | Excel Worksheet Functions | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| SUMPRODUCT | Excel Discussion (Misc queries) | |||
Linear Mode
