View Single Post
 
Old 08-11-2006, 11:51 PM
SerenityNetworks SerenityNetworks is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 37
SerenityNetworks
Default

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]
Reply With Quote