Max IF

  • Thread starter Thread starter LiAD
  • Start date Start date
L

LiAD

Hi,

What is the easiest way to make a max/av/min IF formulas?

Supposing I have the following list

A 1
B 2
B 2
C 3
A 5

I would like a function that will calculate the max av and min for A, B and
C hence returning the following output.

Max Av Min
A 5 3 1
B 3 2.5 2
C 3 3 3

I know how but it seems more awkward that it needs to be.

Thanks
LiAD
 
Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula>}"

=MAX(IF(A1:A5="A",B1:B5))
=AVERAGE(IF(A1:A5="A",B1:B5))
=MIN(IF(A1:A5="A",B1:B5))


If this post helps click Yes
 
Back
Top