|
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? |
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? |
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? |
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? |
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? |
| All times are GMT +1. The time now is 10:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com