help me!

G

Guest

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

Norman Harker

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????????????????,??!?????????
 
G

greg

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????????????????,??!?????????
 
N

Norman Harker

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.
 
N

Norman Harker

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top