Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I am working on a spreadsheet app for a department here at work, and I need get the count of rows given multiple criteria...but then also need to get the average of the values in another column, of those same rows. I have this so far to get the count of rows: =SUMPRODUCT(--('RAW DATA'!C7:C1000="Europe"),--('RAW DATA'!D7 ![]() Now I just need to find a way to make another function that takes the rows produced by that, and gets an average of the values in column J. I'm thinking that I can somehow nest a SUBTOTAL in there, but I can't get it to work. Any suggestions? |
#2
![]() |
|||
|
|||
![]()
Here is a solution for anyone that could use it.
from a gentleman at another board: =SUMPRODUCT(--(C7:C1000="Europe"),--(D7 ![]() ![]() Or if you use Excel 2007 or newer: =AVERAGEIFS(J:J,C:C,"Europe",D ![]() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nesting SUMIF within SUMPRODUCT | Excel Worksheet Functions | |||
nesting sumproduct with subtotal | Excel Worksheet Functions | |||
Average nesting within Sumproduct? | Excel Worksheet Functions | |||
Excel : Nesting of functions such as sumproduct and sumif | Excel Worksheet Functions | |||
subtotal nesting errors new this month | Excel Worksheet Functions |