Looking for

[MacBookProUser]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am using the AverageIf function to determine the average value of a set of numbers that match the criteria.

In this case, I have a worksheet with rows of data and the AverageIf function evaluates values in column A and averages the corresponding values in column C.

I would also like to determine the max/min values but there isn't a conditional max/min function counterpart to AverageIf.

Does anyone have any ideas?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am using the AverageIf function to determine the average value of a set of
numbers that match the criteria.

In this case, I have a worksheet with rows of data and the AverageIf function
evaluates values in column A and averages the corresponding values in column
C.

I would also like to determine the max/min values but there isn't a
conditional max/min function counterpart to AverageIf.

Does anyone have any ideas?

One way (array entered with CMD-RETURN):

=MAX(IF(A1:A100>0,C1:C100))

or

=MIN(IF(A1:A1000="Blue",C1:C100))

 

[MacBookProUser]

One way (array entered with CMD-RETURN):

=MAX(IF(A1:A100>0,C1:C100))

or

=MIN(IF(A1:A1000="Blue",C1:C100))

Thank you for the answer, it worked perfectly.

I would like to learn more, is there a book you would recommend for using Excel for detailed data analysis?

 

[JE McGimpsey]

One way (array entered with CMD-RETURN):

=MAX(IF(A1:A100>0,C1:C100))

or

=MIN(IF(A1:A1000="Blue",C1:C100))

Thank you for the answer, it worked perfectly.

I would like to learn more, is there a book you would recommend for using
Excel for detailed data analysis?[/QUOTE]

There are dozens of books, and I don't have a clear favorite.

There are also a huge number of web sites that have tons of examples
(good and bad, unfortunately). Searching these groups:

http://groups.google.com/advanced_search?q=group:*excel*

is a good way to find examples from lots of folks.

I've recommended my friend John Walkenbach's books before. In this case
his "Excel 2003 Formulas" would probably be the best - most things are
applicable cross platform.

But if you're looking for a book, I'd recommend going to the library or
a bookstore and browsing through the choices. Learning styles differ,
and yours may be much different than mine. Pick one that has a style
that makes sense to you.