I have a table like this enter image description here

how can I do the same thing in Numbers like this

enter image description here

the screenshot comes from excel, if I do the same thing in Numbers, I will get a complain like this:The range E3:E7 can’t be used as a single value.

  • Your formula shows =SUM(B5:J5/B$1:J$1) where are you using E3:E7? And, looking at the contents of E3 to E7 you have a date, a $ and two values... So you won't be using that as a range anyway. – Solar Mike Sep 4 '17 at 19:32
  • Can we assume you know how to pin columns and rows as relative and absolute in Excel or Numbers? (The difference between =B$1/B5 and =$B1/B5) and then how to copy formulas to neighboring cells? – bmike Sep 4 '17 at 19:39
  • @SolarMike thanks for you reply, the E3:E7 is the thing in my numbers, the photos come from excel, I just want to achieve the same thing in numbers which excel do the way the photo shows – hongfengzhou Sep 5 '17 at 8:38
  • @bmike yes, I know – hongfengzhou Sep 5 '17 at 8:40
  • @hongfengzhou You state E3:E7 in the last sentence of your question - which is why I query it.... – Solar Mike Sep 5 '17 at 8:50

You can do this with another area used for intermediate computation. I use another table on a separate Reference sheet.


| 1       | 2       | ...     | SUM(C1:C10) |
| 3       | 4       | ...     |             |
| A1 / A2 | B1 / B2 | ...     |             |

(The bottom row would be in the other table.)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .