Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Compile numbers from multiple worksheets
I have a workbook with over 100 worksheets in it. I need to be able to total
numbers from specific cells on all pages into my cover page. Can someone help? |
#2
|
|||
|
|||
Something like
=SUM(Sheet2:Sheet100!A1) and so forth? -- HTH RP (remove nothere from the email address if mailing direct) "jjneedshelp" wrote in message ... I have a workbook with over 100 worksheets in it. I need to be able to total numbers from specific cells on all pages into my cover page. Can someone help? |
#3
|
|||
|
|||
Create a user-defined function SheetSum that loops through the sheets
and sums the relavant ranges. here's the code : Function SheetSum(ByVal InData As Range) As Variant Dim wsCurrent As Worksheet Dim CurSum As Double CurSum = 0 For Each wsCurrent In Worksheets CurSum = CurSum + wsCurrent.Range(InData.Address).Value Next wsCurrent SheetSum = CurSum End Function to call this function to add , for example, the contents of range A2 in all sheets, enter this formula = SheetSum(A2). HTH Fadi www.chalouhis.com/XLBLOG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
fax multiple worksheets | Excel Worksheet Functions | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |