Remember Me?

#1
June 29th 09, 02:43 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Mar 2009 Posts: 17
=sum() for multiple sheets?

Hey guys so i have a quick question.

I have 50 sheets numbered 1-50 that each have a value in H12. I want to get
the sum of all of those numbers from sheets 1-50.

How would i go about doing that?

Thanks for the help in advance!

#2
June 29th 09, 02:47 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Mar 2009 Posts: 8,521
=sum() for multiple sheets?

=sum(1:50!H12)

If this post helps click Yes
---------------
Jacob Skaria

"tripflex" wrote:

Hey guys so i have a quick question.

I have 50 sheets numbered 1-50 that each have a value in H12. I want to get
the sum of all of those numbers from sheets 1-50.

How would i go about doing that?

Thanks for the help in advance!

#3
June 29th 09, 02:48 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jun 2009 Posts: 1
=sum() for multiple sheets?

Try

=Sum('1:50'!H12)

--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Tanya Excel Discussion (Misc queries) 1 April 20th 09 08:57 PM Greg in CO[_2_] Excel Worksheet Functions 0 September 18th 08 05:51 PM Dr Dan Excel Discussion (Misc queries) 14 November 4th 07 11:32 AM Amaxwell Excel Worksheet Functions 4 August 17th 06 06:23 AM Kathy Excel Worksheet Functions 0 July 26th 05 01:23 AM

All times are GMT +1. The time now is 06:02 PM.