Linking sumif formula to the data

  • Thread starter Thread starter Jarod
  • Start date Start date
J

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.
 
Certainly, you can address ranges in other worksheets, as in:

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

Does that help?
Fred
 
Back
Top