When I compute this function: =IF(Q48=Protected!C27,+Q48,"") -- I get
results, but if I insert a range rather than a reference to only one cell, I
get ### signs where my calculation should be.
If I try to compute: =IF(Q48=Protected!C27:C35,+Q48,"")

then I get the error symbol of ### rather than a computation. What am I
doing wrong.

Up all night on this!