MIN.IF on Excel 2016 -> Range error #Valeur!

Copper Contributor



I have a major issue with an Excel Formula.


I want to make function MIN, MAX and STANDARD DEVIATION with condition

I also use function INDIRECT to set my range.

Here, before applied function MIN I want to exclude cells = "" 

My range look correctly created with INDIRECT but when I eluate i obtain an error: #VALEUR!

I have no idea how to correct this formula !....


Explain me how can I post a file here to better understand my issue


Thanks for help






1 Reply


If you cannot attach a sample workbook directly, you can upload it to a cloud service such as OneDrive, Google Drive or Dropbox, then share it and obtain a link that you can post in a reply.

Alternatively, you can attach it to a private message to me.