Numbers giving a `can’t be used as a single value` error
The roundup function needs to be applied to each of the values in the range you give,

Or, you need to use vlookup() for example to extract the particular value from that range and then apply the roundup function.