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

[Gabin37]

Hello,

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

Gabin

[#2]

@Gabin37 

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.