Select min value from a range [SOLVED]

[mr_hiboy]

Hi all,


I'm looking to count values and select min price in the range on a specific date.


The count bit is easy, but getting a little stuck trying to find the min value (exc 0).


Example here https://dl.dropboxusercontent.com/u/9071274/MinVal.xlsx


Thanks

Paul

 

[Luke M]

Sounds like a MinIf type of problem:

http://chandoo.org/forums/topic/maxif-and-minif

 

[NARAYANK991]

Hi Paul ,


Just for reference :


=MIN(IF($B$7:$B$16=$B$2,IF($D$7:$D$16>0,$D$7:$D$16)))


entered as an array formula , using CTRL SHIFT ENTER.


Narayan

 

[mr_hiboy]

Two gents - if only minif was as simple as sumif


Thanks