breezer123
New Member
- Joined
- Jul 13, 2020
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
Hi! Thank you for reading my question. I am trying to find the minimum value of a few ranges of cells excluding zero. I know if it is a contiguous range that you can do small(countif(,0)+1). However, I am getting a #value error when I try to have multiple ranges. For example =SMALL((K32:K42,W32:W42,AI32:AI42,AU32:AU42),COUNTIF((K32:K42,W32:W42,AI32:AI42,AU32:AU42),0)+1). I am trying to find the minimum value of K32:K42,W32:W42,AI32:AI42,AU32:AU42. I appreciate any help! Thanks!!