Aggregate Help

[dbrown14]

I'm trying to do a simple example of an aggregate function before I get too far into my project and find out things won't work out. So the example I made was to count numbers which are bigger than 200 in a array, and my formula came out to be:

=AGGREGATE(2,6,('array1'/('array1'>200)))

I've worked with the aggregate function before and I believe this should work, but I always get a #VALUE! error. Please help me solve this problem using the aggregate function.

 

[Gerald Higgins]

Well I'm using 2003 and I haven't even got an AGGREGATE() function.

If you want to count how many numbers in an array are larger than 200, you can use COUNTIF.
For example

=countif(a1:b2,">200")

Replace "a1:b2" with whatever the address of your array is.

 

[dbrown14]

Yes, that does work but the main purpose of my question was help using and understanding the aggregate function and the extent of what it's capable of doing.

Thanks for the reply though!!