Dear all
I am working with an Excel Sheet, where I want to find out Minimum, Maximum, and Average Number of a specific Column, given a specific criteria.
I am using the following formula and am able to get the Maximum Value from a specific column.
Now when I try to find Minimum, it always give me Zero Value.
The formula which is displaying the Maximum Value is this..
{=MAX((Sheet1!$D$3:$D$503>=(--$K$4))*((Sheet!!$D$3:$D$503<=(--$Q$4))*((Sheet1!$F$3:$F$503=$D$4))*(Sheet1!$E$3:$E$503=C15)*(Sheet1!$AM$3:$AM$503)))}
Where:
$K$4 and $Q$4 are dates (To search between dates)
$D$4 is first criteria
C15 is second criteria
and $AM$3:$AM$503 is the column from where its getting the maximum value.
When I use the same above formula with MIN, the result is always Zero, which is not correct according to my data.
Thanks in advance for help.
Bookmarks