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