Hello xlstime!
Your formula won't work
Values in the array will be multiplied by 0 if it dose not meets the
criteria. It will be multiplied by 1 if it meets the criteria.
So using MIN function in SUMPRODUCT will give 0, if there is any value in
the array which does not meets the criteria.
O
Hi Santosh,
u can try sumproduct with min or max
try this
=SUMPRODUCT(MIN((A2:A10=Criteria1)*(B2:B10=Criteria2)*(C2:C10)))
On Fri, Mar 1, 2013 at 1:11 AM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hello Group,
>
> Need a small help on how to calculate the max with two or more
Dear Santosh,
Please try it..
For Max with two condition
=MAX(IF(($A$2:$A$20=$F6)*($B$2:$B$20=$G6),$C$2:$C$20,""))
with ctrl+Shift+enter
for Min with two conditon
=MIN(IF(($A$2:$A$20=$F6)*($B$2:$B$20=$G6),$C$2:$C$20,""))
With ctrl+shift+enter
See attachment, Hope it will help for you..
On
That's WAY too vague.
Can you give us some sample data and how you want to calculate it?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As l
