08-11-2006, 11:51 PM
|
Advanced Beginner
|
|
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 37
|
|
Yes, it is possible. You need to use an "array" formula. You will find it very handy. It takes a little getting used to, but once you've got it then you will find you use it all the time.
Where the functions countif and sumif will only work on one set of criteria, an array formula will let you work with multiple criteria - as many as you need. Cool!
The following link has the best explanation that I've seen. http://www.cpearson.com/excel/array.htm
Regards,
Andrew
[/url]
|