Prev: Preview Excel 2007 files in Outlook from SharePoint
Next: Sumproduct Approach
From: Jarod on 6 May 2010 17:02
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.
From: Fred Smith on 6 May 2010 19:17
Certainly, you can address ranges in other worksheets, as in:

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

Does that help?
Fred

"Jarod" <Jarod(a)discussions.microsoft.com> wrote in message
news:AC36BBF8-7AC4-46A3-B0A7-0ECB0310E189(a)microsoft.com...
> 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.

 | 
Pages: 1
Prev: Preview Excel 2007 files in Outlook from SharePoint
Next: Sumproduct Approach