help me!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

我有这样一个问题：在Excel中，第10个工作表A1å•å…ƒæ ¼æ˜¯ç¬¬1至第9工作表A1å•å…ƒæ ¼çš„和值，现在还希望当指å‘第10个工作表A1å•å…ƒæ ¼æ—¶ï¼Œèƒ½å‡ºçŽ°ä¸€ä¸ªå¼¹å‡ºçª—å£ï¼Œé‡Œé¢åˆ†åˆ«æ˜¾ç¤ºå‡ºç¬¬1至第9工作表A1å•å…ƒæ ¼çš„值。请告诉我应该怎样完æˆï¼Œè°¢è°¢ï¼æœ€å¥½ç»™å‡ºè¯¦ç»†æ­¥éª¤ã€‚
 
Hi!

I can forward for translation if you want but response will take 24
hours.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
????????:?Excel?,?10????A1?????1??9???A1??????,?????????10????A1????,?
????????,????????1??9???A1????????????????,??!?????????
 
I have this kind of question: In Excel, the 10th work sheet A1 unit
standard is 1st to the 9th work sheet A1 unit standard and the value,
now also hoped when aims at the 10th work sheet A1 unit standard, can
appear to spring the window, inside separately demonstrates 1st to the
9th work sheet A1 unit standard value. How please tell me to be
supposed to complete, thanks! Best produces the detailed step.

From an online English to Chinese(simplified) translator. Can't decide which
is easier to understand!

????????:?Excel?,?10????A1?????1??9???A1??????,?????????10????A1????,???????
??,????????1??9???A1????????????????,??!?????????
 
Hi!

I think our poster might want:

=SUM(Sheet1:Sheet9!A1:A1)

But I think the Chinese is easier to understand.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi!

A more accurate translation:

I have this problem: In Excel, cell A1 in worksheet 10 shows the
total of cell A1 in worksheets 1to 9. What I hope to do is when
pointing to cell A1 in worksheet 10, a window will pop up showing the
value in cell A1 of worksheets 1 to 9. Please tell me how to do it,
preferably with detailed steps. Thank you.

Solution was a good guess at:
=SUM(Sheet1:Sheet9!A1:A1)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top