SOLVED

Question

New Contributor

Hi,

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)
Solution

@Faithtu 

=MIN(IFERROR(C2:C9,""))

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 

@Quadruple_Pawn 

Thank you so much! 

It worked!

I really appreciate all of your help. 

Let me know if I can assist you with anything.