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
n,
As long as ever you can.” - John Wesley
-
From: santosh subudhi
To: excel-macros
Sent: Thu, February 28, 2013 2:41:38 PM
Subject: $$Excel-Macros$$ max if and min if
Hello Group,
Need a small help on how to calculat
Hello Group,
Need a small help on how to calculate the max with two or more conditions.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www
