Forum Discussion

Gabin37's avatar
Gabin37
Copper Contributor
Aug 23, 2022

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

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

 
 

 

 

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.

Resources