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?