| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111007 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| export multiple sheets to multiple excel files | Excel Discussion (Misc queries) | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Linear Mode
