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(--(C7:C1000="Europe"),--(D7
1000="Equity"),--(E7:E1000="Urgent"),--(F7:F1000="Inactive"),--(W7:W1000<>"ERROR"))
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. Would I need something like the following inside of the SUMPRODUCT:
=SUBTOTAL(1,'RAW DATA'!J7:J1000)
Any suggestions would be greatly appreciated!
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(--(C7:C1000="Europe"),--(D7
1000="Equity"),--(E7:E1000="Urgent"),--(F7:F1000="Inactive"),--(W7:W1000<>"ERROR"))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. Would I need something like the following inside of the SUMPRODUCT:
=SUBTOTAL(1,'RAW DATA'!J7:J1000)
Any suggestions would be greatly appreciated!
Last edited: