Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: multi-worksheet sum

0 views
Skip to first unread message

Bob Phillips

unread,
Apr 16, 2010, 1:48:40 PM4/16/10
to
=SUM(Sheet1:Sheet3!A1:A10)

--

HTH

Bob

"无名" <co...@hz.cn> wrote in message
news:ux2X7rW3...@TK2MSFTNGP05.phx.gbl...
> 大家好！
> 如何对多工作表中符合行列的数据求和，谢谢！
>
> How to sum multiple sheets，thank!
>
>


MRT

unread,
Apr 18, 2010, 11:13:41 AM4/18/10
to
建议... 与其对该公式费时间和努力，毋宁重新设计数据库。
 
You are recommended to remake the database design
than investing a good deal of time and effort to make that formula.

Group(sheet) name type qty.
1 D 20*40 4
3 B 20*50 2
2 C 20*60 3
5 C 20*50 3
4 A 20*40 1

--
MRT

"无名" <co...@hz.cn> wrote in message news:ux2X7rW3...@TK2MSFTNGP05.phx.gbl...

houninghn

unread,
Apr 18, 2010, 2:14:17 PM4/18/10
to
用sum函数

"无名" <co...@hz.cn> 写入消息 news:ux2X7rW3...@TK2MSFTNGP05.phx.gbl...

半熟牛

unread,
Apr 19, 2010, 1:46:22 AM4/19/10
to
It's conditional sumary.
Its anwser shoud be more complex.

"Bob Phillips" <bob.ph...@somewhere.com> 写入消息新闻:ucOlO0Y3...@TK2MSFTNGP02.phx.gbl...

无名

unread,
Apr 19, 2010, 8:12:03 AM4/19/10
to
牛，我是无名，新帆的无名。
说说公式吧，谢谢.


半熟牛

unread,
Apr 20, 2010, 2:04:14 AM4/20/10
to
好难，在想……

"无名" <co...@hz.cn> 写入消息新闻:eCiPIm73...@TK2MSFTNGP02.phx.gbl...

无名

unread,
Apr 20, 2010, 4:19:39 AM4/20/10
to
如何用SUM


0 new messages