Formula help for multiple worksheets

J

Jeremy

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?
 
B

Ben

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.
 
J

Jeremy

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.
 
R

Roger Govier

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)
 
J

Jeremy

Perfect
Thank you very much. I was refrencing the worksheet only once in the
formula causing it to not work.

Thanks again
 
Top