| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using Two Worksheets To Capature Data
I have one worksheet that is the master file/worksheet. I want to create/use
another worksheet that sums/counts data from the master file/worksheet. How do I input formulas on the second worksheet to sum/count data from the first? |
|
#2
|
|||
|
|||
|
Using Two Worksheets To Capature Data
Something like =Sum(Sheet1!A2:A65536) will sum all the values in column A,
assuming you're using Row 1 as the headings. ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I have one worksheet that is the master file/worksheet. I want to create/use another worksheet that sums/counts data from the master file/worksheet. How do I input formulas on the second worksheet to sum/count data from the first? |
|
#3
|
|||
|
|||
|
Using Two Worksheets To Capature Data
I copied the formula on to my second worksheet. I keep getting a popup
window titled "Update Values:Report" that wants a excel file name. Should this happen? Both worksheets are in the same Excel file. "Anne Troy" wrote: Something like =Sum(Sheet1!A2:A65536) will sum all the values in column A, assuming you're using Row 1 as the headings. ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I have one worksheet that is the master file/worksheet. I want to create/use another worksheet that sums/counts data from the master file/worksheet. How do I input formulas on the second worksheet to sum/count data from the first? |
|
#4
|
|||
|
|||
|
Using Two Worksheets To Capature Data
Show your formula, please, Roy. And give us the name of your worksheets.
************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I copied the formula on to my second worksheet. I keep getting a popup window titled "Update Values:Report" that wants a excel file name. Should this happen? Both worksheets are in the same Excel file. "Anne Troy" wrote: Something like =Sum(Sheet1!A2:A65536) will sum all the values in column A, assuming you're using Row 1 as the headings. ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I have one worksheet that is the master file/worksheet. I want to create/use another worksheet that sums/counts data from the master file/worksheet. How do I input formulas on the second worksheet to sum/count data from the first? |
|
#5
|
|||
|
|||
|
Using Two Worksheets To Capature Data
=Sum(Sheet1!H24:H266)
Overall Report = This is the worksheet where the data is stored and pulled from. Totals = This is the worksheet where I want to capture totals. The Overall Report worksheet is very detailed and lengthy. It goes to column AF and new rows are added daily. I will be pulling data from various columns to sum/count (numbers/text) on the Totals worksheet. Each column has its own sum/count (no two columns interact.) "Anne Troy" wrote: Show your formula, please, Roy. And give us the name of your worksheets. ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I copied the formula on to my second worksheet. I keep getting a popup window titled "Update Values:Report" that wants a excel file name. Should this happen? Both worksheets are in the same Excel file. "Anne Troy" wrote: Something like =Sum(Sheet1!A2:A65536) will sum all the values in column A, assuming you're using Row 1 as the headings. ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I have one worksheet that is the master file/worksheet. I want to create/use another worksheet that sums/counts data from the master file/worksheet. How do I input formulas on the second worksheet to sum/count data from the first? |
|
#6
|
|||
|
|||
|
Using Two Worksheets To Capature Data
Okay, so your formula should read (for a total of the values in column A of
the Overall Report worksheet): =SUM('Overall Report'!A2:A65536) ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... =Sum(Sheet1!H24:H266) Overall Report = This is the worksheet where the data is stored and pulled from. Totals = This is the worksheet where I want to capture totals. The Overall Report worksheet is very detailed and lengthy. It goes to column AF and new rows are added daily. I will be pulling data from various columns to sum/count (numbers/text) on the Totals worksheet. Each column has its own sum/count (no two columns interact.) "Anne Troy" wrote: Show your formula, please, Roy. And give us the name of your worksheets. ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I copied the formula on to my second worksheet. I keep getting a popup window titled "Update Values:Report" that wants a excel file name. Should this happen? Both worksheets are in the same Excel file. "Anne Troy" wrote: Something like =Sum(Sheet1!A2:A65536) will sum all the values in column A, assuming you're using Row 1 as the headings. ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I have one worksheet that is the master file/worksheet. I want to create/use another worksheet that sums/counts data from the master file/worksheet. How do I input formulas on the second worksheet to sum/count data from the first? |
|
#7
|
|||
|
|||
|
Using Two Worksheets To Capature Data
Anne,
I must have entered something wrong. I just tried it again with the formula you provided and it works. Not sure what I did the first time around. Thank you very much. "Anne Troy" wrote: Show your formula, please, Roy. And give us the name of your worksheets. ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I copied the formula on to my second worksheet. I keep getting a popup window titled "Update Values:Report" that wants a excel file name. Should this happen? Both worksheets are in the same Excel file. "Anne Troy" wrote: Something like =Sum(Sheet1!A2:A65536) will sum all the values in column A, assuming you're using Row 1 as the headings. ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I have one worksheet that is the master file/worksheet. I want to create/use another worksheet that sums/counts data from the master file/worksheet. How do I input formulas on the second worksheet to sum/count data from the first? |
|
#8
|
|||
|
|||
|
Using Two Worksheets To Capature Data
Cool. :)
************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... Anne, I must have entered something wrong. I just tried it again with the formula you provided and it works. Not sure what I did the first time around. Thank you very much. "Anne Troy" wrote: Show your formula, please, Roy. And give us the name of your worksheets. ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I copied the formula on to my second worksheet. I keep getting a popup window titled "Update Values:Report" that wants a excel file name. Should this happen? Both worksheets are in the same Excel file. "Anne Troy" wrote: Something like =Sum(Sheet1!A2:A65536) will sum all the values in column A, assuming you're using Row 1 as the headings. ************ Anne Troy www.OfficeArticles.com "roy.okinawa" wrote in message ... I have one worksheet that is the master file/worksheet. I want to create/use another worksheet that sums/counts data from the master file/worksheet. How do I input formulas on the second worksheet to sum/count data from the first? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'Consolidate' data from multiple worksheets | Excel Discussion (Misc queries) | |||
| sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
| Match and index functions: corrlating data from 2 worksheets | Excel Worksheet Functions | |||
| data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
