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

Visitor

Hello,

 

I have a major issue with an Excel Formula.

66852_63035d819dfe8335687401.png

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

 
 

 

 

2eme.png

1 Reply

@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.