![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
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 |
![]() |
jvieille | Misc | 1 | 02-11-2006 06:26 AM |
import multiple categories | stormin.norm | Outlook | 0 | 01-30-2006 01:36 PM |