Linking sumif formula to the data

[Jarod]

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.

 

[Fred Smith]

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

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

Does that help?
Fred