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.



Andrew Mackenzie wrote:

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

--

Dave Peterson