View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default =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!