MAXIF / SUMPRODUCT??

  • Thread starter Thread starter Andrew Mackenzie
  • Start date Start date
A

Andrew Mackenzie

Hi All,

It would be very useful for me to be able to use SUMPRODUCT to get the
maximum and minimum values depending on type similar to using it instead of
SUMIF. Can anyone tell me if it is possible to do this and, if so, how?

Many thanks in advance.

Andrew
 
=sumproduct() won't work for this, but you can use an array formula:

=max(if(a1:a10="something",B1:b10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can only use the whole column in xl2007.
 
Back
Top