Is it possible to use the sumif function across several worksheets within a single Excel file? For example, can the formula =sumif("W1"!$1:$1,$A3,"W1"!$3,$3), which returns the sum of values in row 3 on worksheet W1 in columns for which the row 1 value equals the value in cell A3, be extended to cover worksheets W2 and W3 as well? If so, how would this be done? Thanks!
Results 1 to 2 of 2
Thread: Excel (2002)
-
New Lounger
- Join Date
- Jan 2001
- Location
- New York
- Posts
- 7
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2003-03-25 05:21Excel (2002)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Super Moderator
- Join Date
- May 2002
- Location
- Canberra, Australian Capital Territory, Australia
- Posts
- 3,303
- Thanks
- 0
- Thanked 93 Times in 91 Posts
2003-03-25 08:21Re: Excel (2002)
Hi,
The easiest way would to be to use multiple sumifs in the one formula, eg:
==SUMIF('W1'!$1:$1,$A3,'W1'!$3:$3)+SUMIF('W2'!$1:$ 1,$A3,'W2'!$3:$3)+SUMIF('W3'!$1:$1,$A3,'W3'!$3:$3)
CheersCheers,
Paul Edstein
[MS MVP - Word]
