New Contributor


This formula returns a #ERROR, and I can't see why.

I've tried at least five ways to find the minimum value from a separate sheet. From putting in all the numbers to MIN=(Sheet1!C2:C9).

I've used =MIN((SheetRawData!C2:C9)).

Any feedback would be so appreciated. 

2 Replies
best response confirmed by Hans Vogelaar (MVP)



Maybe there is an error in range C2:C9. You can add IFERROR to exclude errors. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.

min range.JPG 


Thank you so much! 

It worked!

I really appreciate all of your help. 

Let me know if I can assist you with anything.