How to list the numbers identified by AVERAGEIFS and other -IFS functions?

[Rnkhch]

Hello,

I have several numbers in column A, and I use the AVERAGEIFS function in cell B1 to calculate the average of numbers that are greater than or equal to 70 and less than or equal to 100, which is very easy and works very well. Now, what if I wanted a list generated of all the numbers that met my criteria, say in column C. Is there a way to do that without VBA?

This would of course easily apply to other -IFS functions such as MAXIFS and MINIFS.

Also I make my own "STDEVIFS" function, by using as many required nested IF functions, in the form of an array formula. It would be nice to be able to get the list of these values too.

Thanks much for any input!

 

[Fluff]

You can only mark one post as the solution. I would suggest leaving it as-is, because you can't use the filter function at work.

 

[Toadstool]

...and because I need another 2,152 Solutions to catch up with Fluff

 

[Rnkhch]

Sorry I just saw these last 2 posts since they were on page 2. I was wondering where they were because I got the notifications. The page 1 and 2 buttons are so tiny I totally missed them

Sure, I'll leave the solution as is lol ?