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 |