Linking sumif formula to the data
 

Is there a way to link a sumif formula to the data on a different worksheet
that makes up the sum of the formula. If I click on the cell that contains
the sum, the data that makes up that sum will show up on a different
worksheet. Don't know if possible. Thanks.

Linking sumif formula to the data
 

Certainly, you can address ranges in other worksheets, as in:

=sumif(sheet2!A:A,"criteria",sheet3!B:B)

Does that help?
Fred

"Jarod" wrote in message
...
Is there a way to link a sumif formula to the data on a different
worksheet
that makes up the sum of the formula. If I click on the cell that
contains
the sum, the data that makes up that sum will show up on a different
worksheet. Don't know if possible. Thanks.