#ref error in google sheets. There are any references about #ref error in google sheets in here. you can look below.