|
|
#2
08-11-2006, 11:51 PM
|
|||
|
|||
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] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to get cells to calculate time?
|
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
| Don't count 0 in a chart | Rmaisone | Excel | 0 | 08-21-2006 12:26 PM |
| Automatically entering/fill data in cells in Excel 2003 | dipdog | Excel | 0 | 08-17-2006 08:37 AM |
|
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
|
Filtering past or future events in DRW query criteria
|
jvieille | Misc | 1 | 02-11-2006 06:26 AM |
Windows 10 
Office 2016
Threaded Mode