|
|
#1
02-16-2006, 06:55 AM
|
|||
|
|||
Multiple criteria in SUMIF?
Hi, I'm after some help regarding SUMIF.
Basically I want to add up all of the numbers in column O that have a 100 in column A, and a 6 in column D. I can do this separately like so: SUMIF(A:A,100,O:O) and SUMIF(D: D,6,O:O) but that doesn't help me, because I want to filter out any row which doesn't have a 100 in A and a 6 in D. Any help would be appreciated. PH. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Multiple Folders in Outlook | Cabbage1031 | Outlook | 0 | 05-23-2007 10:56 AM |
| Help with consolidating multiple records into one | wbiggs2 | Excel | 0 | 11-30-2006 01:02 PM |
| How to count cells containing data and meet certain criteria | AdamNT | Excel | 1 | 08-11-2006 11:51 PM |
 Filtering past or future events in DRW query criteria
|
jvieille | Misc | 1 | 02-11-2006 06:26 AM |
| import multiple categories | stormin.norm | Outlook | 0 | 01-30-2006 01:36 PM |
Threaded Mode