Hi...

I'm... VERY... new to excel

Problem is:

I have cells repeating the values from another sheet (is there a better option than rept?):
| B | C
1|
2| =REPT('Sheet1'!G43, 1) | =REPT('Sheet1'!H43, 1)

which returns:

| B | C
1|
2| 90 | 95

and then I try:

=AVERAGE(B2:C2)

and I just get #DIV/0.

Why?

Is it trying to calculate the underlying formula rather than the value?