Hi Guys! I am trying to set up a SUMIF function with more than one criteria and it's not working.
Does anyone have good examples of just such a SUMIF function.
Thanks!
Results 1 to 3 of 3
-
New Lounger
- Join Date
- Apr 2004
- Posts
- 3
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2006-05-18 12:57SUMIF Function Formula with Multiple Criteria (Excel XP)
-
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.
-
Platinum Lounger
- Join Date
- Feb 2002
- Location
- A Magic Forest in Deepest, Darkest Kent
- Posts
- 5,681
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2006-05-18 13:02Re: SUMIF Function Formula with Multiple Criteria
Without your criteria it is difficult to answer but you may want to use sumproduct and example can be found here http://www.ozgrid.com/Excel/sum-if.htm
Jerry
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2006-05-18 13:40Re: SUMIF Function Formula with Multiple Criteria (Excel XP)
You can also find several examples by clicking on the Search button in the Lounge menu bar and searching for sumif multiple criteria.
