| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help for multiple worksheets
I have 2 worksheets one is named cons and the other rep. I am trying to
get the data from the rep to cons using a formula written like =SUMIF(B1:B4,"Jane Doe",C1:C4). The formula is for data in the rep worksheet. How would I tell it to pull the data from the rep worksheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help for multiple worksheets
the easiest way to do what you want is todo the following:
in the cell that you want to copy the data into place an eaquals sign...then go to the worksheet that has the data you want to replicat and click on the cell that has the data. That's it...you can then drag down using the small black plus sign (bottom right corner of the cell) to copy the formula down. "Jeremy" wrote: I have 2 worksheets one is named cons and the other rep. I am trying to get the data from the rep to cons using a formula written like =SUMIF(B1:B4,"Jane Doe",C1:C4). The formula is for data in the rep worksheet. How would I tell it to pull the data from the rep worksheet? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help for multiple worksheets
I understand how to get the data from one worksheet to another but the
proplem is I am trying to formulate the data the other sheet will bring over from the formula I listed. "Ben" wrote: the easiest way to do what you want is todo the following: in the cell that you want to copy the data into place an eaquals sign...then go to the worksheet that has the data you want to replicat and click on the cell that has the data. That's it...you can then drag down using the small black plus sign (bottom right corner of the cell) to copy the formula down. "Jeremy" wrote: I have 2 worksheets one is named cons and the other rep. I am trying to get the data from the rep to cons using a formula written like =SUMIF(B1:B4,"Jane Doe",C1:C4). The formula is for data in the rep worksheet. How would I tell it to pull the data from the rep worksheet? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help for multiple worksheets
Hi Jeremy
=SUMIF(Rep!B1:B4,"Jane Doe",Rep!C1:C4) If the sheet name has spaces, then enclose within single quotes =SUMIF('Rep 1'!B1:B4,"Jane Doe",'Rep 1'!C1:C4) -- Regards Roger Govier "Jeremy" wrote in message ... I understand how to get the data from one worksheet to another but the proplem is I am trying to formulate the data the other sheet will bring over from the formula I listed. "Ben" wrote: the easiest way to do what you want is todo the following: in the cell that you want to copy the data into place an eaquals sign...then go to the worksheet that has the data you want to replicat and click on the cell that has the data. That's it...you can then drag down using the small black plus sign (bottom right corner of the cell) to copy the formula down. "Jeremy" wrote: I have 2 worksheets one is named "cons" and the other "rep". I am trying to get the data from the "rep" to "cons" using a formula written like =SUMIF(B1:B4,"Jane Doe",C1:C4). The formula is for data in the "rep" worksheet. How would I tell it to pull the data from the "rep" worksheet? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help for multiple worksheets
Perfect
Thank you very much. I was refrencing the worksheet only once in the formula causing it to not work. Thanks again "Roger Govier" wrote: Hi Jeremy =SUMIF(Rep!B1:B4,"Jane Doe",Rep!C1:C4) If the sheet name has spaces, then enclose within single quotes =SUMIF('Rep 1'!B1:B4,"Jane Doe",'Rep 1'!C1:C4) -- Regards Roger Govier "Jeremy" wrote in message ... I understand how to get the data from one worksheet to another but the proplem is I am trying to formulate the data the other sheet will bring over from the formula I listed. "Ben" wrote: the easiest way to do what you want is todo the following: in the cell that you want to copy the data into place an eaquals sign...then go to the worksheet that has the data you want to replicat and click on the cell that has the data. That's it...you can then drag down using the small black plus sign (bottom right corner of the cell) to copy the formula down. "Jeremy" wrote: I have 2 worksheets one is named "cons" and the other "rep". I am trying to get the data from the "rep" to "cons" using a formula written like =SUMIF(B1:B4,"Jane Doe",C1:C4). The formula is for data in the "rep" worksheet. How would I tell it to pull the data from the "rep" worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Copying a formula to multiple worksheets | Excel Worksheet Functions | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| use central formula on many worksheets, central affect allsheets | Excel Worksheet Functions | |||
Hybrid Mode
